The Azure SQL Workshop

Translate your existing SQL Server skills to Azure SQL with Bob Ward and Anna Hoffman. You will gain a foundational knowledge of what to use when, as well as how to configure, monitor, and troubleshoot the “meat and potatoes” of SQL Server in Azure: Security, Performance, and Availability. You will learn about not only the “what”, but also the “how” and the “why”. You’ll also walk away with resources and tools so you can go as deep as your scenario requires and get hands on for free.

Migrating to Azure SQL Managed Instance

Many SQL professionals are looking at Azure and trying to learn the best way to migrate their workloads and SQL instances. Come learn in this session about how to migrate to Azure SQL Managed instance by learning the lifecycle of assess, migrate, optimize, and manage your Azure SQL Managed Instance. You will learn how to use all the latest tools from Microsoft as well as compare SQL Server to Azure SQL Managed Instance.

Inside the Memory of SQL

In this session I'll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I'll also describe differences in memory management for SQL Server on Linux and Azure SQL.

SQL Edge to Cloud

SQL is everywhere you need it from the IoT Edge to your datacenter to public clouds. With all of these options, it can be difficult to know which to choose and why each option may be right for your data needs. In this presentation, I’ll review with you all the current released and preview versions of SQL from the edge to the cloud. I’ll compare each of them and discuss why you want to get ahead of the curve by understanding what is possible with the modern SQL data platform. I’ll discuss the technical details of some of these options so you can understand what SQL "flavor" fits your company's needs. This session will include some demos to highlight key innovations with SQL.

Inside SQL Waits, Latches, and Spinlocks

Dive into the internals of waits in SQL Server including latches and spinlocks. In this session, you will learn how SQL Server implements waits, how you can monitor and troubleshoot waits, and a deep dive into specific common wait types. This session will include new wait types specific to Azure SQL. This session is not for the faint of heart as it will be fast and furious. The session will include plenty of demos and back by popular demand the use of the Windows Debugger to peek inside how waits are truly implemented in SQL Server!

Caution: This session can melt your brain.