SQL On Linux by Jim Donahoe | Query Store by Lee Markum

Session #1
Abstract
Are you interested in the new platform that SQL Server runs on? Have you heard of this OS called "Linux" before, and never used it? Well, if you answered yes to either of these questions, this session is for you! Learn about why Microsoft decided to make SQL available on Linux, and how to install, configure, and troubleshoot.

Speaker Bio
Jim lives just outside of Pittsburgh, PA, in a small town called South Park. He enjoys spending time with family and friends. When not working, you could likely find him playing a video game with his Wife, or flying somewhere on Flight Simulator in his basement cockpit setup. He has been in the data business for over 15 years now.

Session #2
Abstract
Query Store has become an indispensable SQL Server performance monitoring and tuning feature. This session offers a Level 200 introduction and practical walkthrough of Query Store, focusing on its ability to capture, store, and analyze query performance metrics. We'll explore why Query Store was introduced, what data it provides, and how it empowers database administrators to identify regressions, enforce plan stability, and leverage Intelligent Query Processing features such as Memory Grant Feedback and DOP Feedback. In addition to understanding how Query Store helps detect and fix performance issues, attendees will learn how to configure it effectively, including important settings like capture modes, cleanup policies, and custom capture thresholds. We’ll also cover new features in SQL Server 2022 that enhance Query Store’s capabilities, such as query hints without code changes and persisted feedback. To wrap up, we’ll highlight powerful community tools and scripts that help extract value from Query Store data and support real-world troubleshooting scenarios. Whether you're new to Query Store or looking to deepen your understanding, this session will equip you to begin unlocking performance improvements in your SQL Server environment.

Speaker Bio
Lee is a SQL Server Database Administrator who started with SQL Server in 2009. Back in the day, he earned an MCTS certification on SQL Server 2008. That was followed up in 2020 with the AZ-900 Azure Fundamentals and DP-900 Microsoft Azure Data Fundamentals certifications. He has officially been a DBA since 2014. Lee has worked for small companies under 100 people to large enterprises with thousands of employees and used databases of all sizes. He has presented at SQL Server Meetups, New Stars of Data, SQL Saturdays, was an online speaker for the RedGate PASS Data Community Summit 2022, and spoke at Saint Louis DevUp in 2024. Lee blogs at LeeMarkum.com, and he loves finding and experimenting with new features in SQL Server. High availability and disaster recover,y as well as performance monitoring and troubleshooting, are of special interest to Lee