DPS Recordings

Session Title: Upgrading/Migrating a Microsoft Data Platform Environment: Experiences from Field Speaker: William Durkin Abstract: In this session we will go over some experiences, thoughts, and pitfalls around upgrading and migrating SQL Server solutions. The audience will hear how different approaches are necessary depending upon business needs and that the most obvious solution isn’t always [...]

Session Title: Building an advanced practice using Azure Data Explorer Speaker: Richard Conway Abstract: In this talk Richard will talk through how to build a scalable, interactive data platform using Azure Data Explorer (ADX) and Kusto Query Language (KQL) based on work he’s been doing with one of his clients. In this deep dive he’ll [...]

Session Title: Getting started with Azure Synapse Analytics, ADF and Azure ML Speaker: Wee Hyong Tok & Nellie Gustafsson Abstract: Data is the fuel of AI. Data engineers and data scientists spend significant time performing data preparation, and feature engineering. Often, the data that sits in diverse data sources spread across the organization, and lots [...]

Session Title: SQL Server in Azure Virtual Machines Reimagined Speaker: Aditya Badramraju & Pam Lahoud Abstract: Most of the enterprise workloads would want both control and Manageability of their databae solutions. For such scenarios, deploying SQL Server in VM is a best choice. By deploying SQL Server in Azure Virtual Machines customers can take advantage [...]

Session Title: Building an Agile Data Warehouse Speaker: Thomas Leblanc Abstract: The Data Vault method can be used in agile development. If you follow 2.0 structure the hubs, links and satellites only have inserts. The difficult or more time consuming part is the Information Mart. This is where views for reporting can be used for [...]

Session Title: Test Driven Database Development Speaker: Magnus Ahlkvist Abstract: Test Driven Development, or TDD, means we start with unit tests, even before writing our code. When done properly, TDD leads to higher quality systems. It gives us good test coverage, it’s automated and it gives us good regression testing. To isolate the unit tests, [...]

Session Title: Query Tuning Internals for the Advanced SQL Developer Speaker: Kevin Kline Abstract: Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans and that SQL Server uses a cost-based optimizer to construct query execution plans. But how does does the optimizer decide the cost of [...]

Session Title: PowerBI Vision, strategy and roadmap Speaker: Patrick LeBlanc Abstract: Power BI is helping organizations large and small, drive a data culture. We will cover our vision and roadmap. You will learn how AI automatically finds patterns in your data, you will learn about how Power BI is built into Teams and Excel to [...]

Session Title: Modernize your SQL applications with the recently enhanced version of Azure SQL Managed Instance Speaker: Borko Novakovic & Srdan Bozovic Abstract: Azure SQL Database Managed Instance offers the best combination of a fully managed cloud service in Azure and compatibility with SQL Server on-premises product. This makes it the recommended destination for SQL [...]

Session Title: Azure SQL Database Performance Tuning Tips and Tricks Speaker: Balmukund Lakhani & Dimitri Furman Abstract: Performance tuning might be seen as magic, and those who can tune might look like magicians. There are no “go-faster” buttons and in reality, performance tuning is more art than magic. In this session we share common performance [...]