Posts

Upgrading/Migrating a Microsoft Data Platform Environment: Experiences from Field By William Durkin

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 [...]

By |August 5th, 2022|DPS Recordings|Comments Off on Upgrading/Migrating a Microsoft Data Platform Environment: Experiences from Field By William Durkin

Building an advanced practice using Azure Data Explorer By Richard Conway

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 [...]

By |August 5th, 2022|DPS Recordings|Comments Off on Building an advanced practice using Azure Data Explorer By Richard Conway

Getting started with Azure Synapse Analytics, ADF and Azure ML By Wee Hyong Tok & Nellie Gustafsson

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 [...]

By |August 4th, 2022|DPS Recordings|Comments Off on Getting started with Azure Synapse Analytics, ADF and Azure ML By Wee Hyong Tok & Nellie Gustafsson

SQL Server in Azure Virtual Machines Reimagined By Aditya Badramraju and Pam Lahoud

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 [...]

By |August 4th, 2022|DPS Recordings|Comments Off on SQL Server in Azure Virtual Machines Reimagined By Aditya Badramraju and Pam Lahoud

Building an Agile Data Warehouse By Thomas Leblanc

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 [...]

By |August 3rd, 2022|DPS Recordings|Comments Off on Building an Agile Data Warehouse By Thomas Leblanc

Test Driven Database Development By Magnus Ahlkvist

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, [...]

By |August 3rd, 2022|DPS Recordings|Comments Off on Test Driven Database Development By Magnus Ahlkvist

Query Tuning Internals for the Advanced SQL Developer By Kevin Kline

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 [...]

By |August 2nd, 2022|DPS Recordings|Comments Off on Query Tuning Internals for the Advanced SQL Developer By Kevin Kline

PowerBI Vision, strategy and roadmap By Patrick LeBlanc

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 [...]

By |August 2nd, 2022|DPS Recordings|Comments Off on PowerBI Vision, strategy and roadmap By Patrick LeBlanc

Modernize your SQL applications with the recently enhanced version of Azure SQL Managed Instance By Borko Novakovic and Srdan Bozovic

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 [...]

By |July 26th, 2022|DPS Recordings|Comments Off on Modernize your SQL applications with the recently enhanced version of Azure SQL Managed Instance By Borko Novakovic and Srdan Bozovic

Azure SQL Database Performance Tuning Tips and Tricks by Balmukund Lakhani & Dimitri Furman

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 [...]

By |July 11th, 2022|DPS Recordings|Comments Off on Azure SQL Database Performance Tuning Tips and Tricks by Balmukund Lakhani & Dimitri Furman