Sessions & Content

Search
Content Type
Conference
Tags
Automated Testing Solutions for Power BI Mathias Thierbach
The session introduces the concept of automated testing and explains how it applies to Power BI solutions, both datasets and reports. Learn about existing tools and approaches and how you can introduce testing scripts to your own CI/CD pipelines.
The video is not available to view online.
Code repos and automated deployment Jens Vestergaard
Join this session if you want to get a guided tour into an example of how you could implement Azure DevOps in your organisation or team. We will be complete the journey from idea to running code
The video is not available to view online.
DataOps 101 – A Better Way to Develop and Deliver Data Analytics John Kerski
Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.
The video is not available to view online.
Generate test data quick, easy and lots of it with the Databricks Labs Data Generator André Kamman
We're not supposed to use production in dev right! But generating proper test data is not easy, get's even harder when you need quite a lot of it. I generate Terabytes of it, and without much trouble. Let me show you how!
The video is not available to view online.
No more data quality surprises in your Databricks, Synapse or Power BI solutions! Dave Ruijter
In this demo-rich session you will learn how you can implement a framework for data quality validation and monitoring, spanning your end-to-end data platform including Power BI!
The video is not available to view online.
Unveiling the magic of CI/CD for SQL Server using GitHub Actions Kevin Chant
In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.
The video is not available to view online.
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.
<<12>>