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.
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.
How to build a data platform in Azure
The video is not available to view online.
Automate checking your database security model
Improve the quality of your T-SQL code with the free tool ScriptDom
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.
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.
Join me to learn how to migrate a traditional DW transformation process to Spark/Scala based platform and reuse existed experience
Is the business logic in your database tested? It should be, and in this talk, we'll talk about how.
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.
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.
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.
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
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.
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 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.
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.
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.