Sessions & Content

Search
Content Type
Conference
Tags
Embedding SQL security practices in your pipelines Stuart Moore
Automate checking your database security model
Finding and Fixing T-SQL Anti-Patterns with ScriptDOM Koen Verbeeck
Improve the quality of your T-SQL code with the free tool ScriptDom
Github and Azure DevOps Duet - SQLBits edition Kevin Chant
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
Limiting permissions in Dynamic SQL with Execute As Russ Loski
Dynamic SQL is great, until it is used to hack your site. In this session we demonstrate how using the T-SQL "Execute AS" command can limit what can be run using dynamic SQL.
Migrate traditional DW transformations to Spark/Scala Sergiy Lunyakin
Join me to learn how to migrate a traditional DW transformation process to Spark/Scala based platform and reuse existed experience
Testing! We're Talking About (Unit) Testing! Dan Mallott
Is the business logic in your database tested? It should be, and in this talk, we'll talk about how.
When you should avoid using bidirectional filters in Power BI Alberto Ferrari
Bidirectional filters are a powerful tool, probably too powerful for most data models. In this quick talk we show the reason why most users should avoid using the feature, unless they understand well the implications.
Adding unit tests to the database deployment pipeline Eduardo Piairo
This talk will address how to add the unit testing framework tSQLt to the database deployment pipeline. The purpose is to reduce the cost of validate every change in the database with a fully automated pipeline.
Disposable Dev environments with Azure DevOps and AzureRM Gavin Campbell
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Making Managed Instance Perform, a dive into storage. John Q Martin
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance included, get the storage configuration wrong and it will not perform. We'll look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need
Power BI Premium on a budget Michael Johnson
Power BI Premium has many features that organisations desire yet the price makes it impractical for most. In this talk you will learn how Power BI Embedded can be used to enable many of these features at a much lower cost.
SentryOne Tools for Productivity and Performance Andy Yun
This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.
<<1>>