Sessions & Content

Search
Content Type
Conference
Tags
An evening with Power BI CAT team Prathy Kamasani
SQL bits and London Power BI user group are brining a Q&A panel with some of Power BI CAT team members to ask everything about Power BI. Join us with your questions
The video is not available to view online.
Azure DevOps trio Kevin Chant
Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.
The video is not available to view online.
Building and managing a Data Platform in Azure Hamish Watson
How to build a data platform in Azure
The video is not available to view online.
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.
DB Engineering: Shall we test the code before we hit prod? Ed Elliott
Deploying untested code to production isn't ideal, manual testing can be slow and unreliable. In this talk we will look at the different types of automated testing we can use for our databases to give us confidence in the quality of the code.
The video is not available to view online.
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.
Lets go deep in SQL Server Unit Testing with Visual Studio Geovanny Hernandez
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
The video is not available to view online.
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.
Would you run production SQL Server on Docker? James Anderson
Should you run SQL Server on physical machines, virtualised, in the cloud or do you run it on Docker? It may sound crazy to run your data tier in ephemeral containers, but I'll discuss the reasons why this might be a good idea.
The video is not available to view online.
<<1>>