22-25 April 2026 
SQLBits 2024
Mastering SQL Server Performance & Optimization Strategies
Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.
In the pursuit of excellence, speed is the engine, and performance is the destination.
Everyone wants their database to go faster, whether it's shaving hours off your ETL process, taking minutes off the runtime for reports, or trimming milliseconds off a critical OLTP query. Every database professional must know where to look and how to tune, whether you have one SQL environment or thousands.
In this full-day session, you'll learn how to take your performance tuning skills to the next level. How to best configure SQL Server as well as how to decipher all metrics it collects can be daunting. Identifying how to distill the data down to actionable information is an integral part of a DBA's job. After this session, you will understand what to look for, how to analyze the data, and you will know how to use an array of tools including query store, performance monitor, and various scripts to get the critical performance information you need. Beyond tools and scripts, you'll become versed in the art and science of reading query plans to help you improve individual query performance. Finally, you'll learn about the newest performance enhancements within SQL Server 2022 and Azure SQL.
You'll leave this knowledge packed session with a clearer understanding of which items to evaluate and how to resolve many issues that plague SQL Server performance.
Speakers
John Morehouse's previous sessions
Mastering SQL Server Performance & Optimization Strategies
Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.
Soaring to New Heights with Accelerated Database Recovery
In this deep technical session, we will uncover the mechanisms of accelerated database recovery that allow for a much smoother flight in the journey of database recovery.
Azure Infrastructure - What Not to Do
This session will high light things I've seen in Azure SQL implementations that have caused issues. Attendees will learn from the mistakes of others to ensure a smooth Azure flight of their own.
Monica Rathbun
sqlespresso.com
Monica Rathbun's previous sessions
Mastering SQL Server Performance & Optimization Strategies
Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.
Mastering TempDB
Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.
Your Performance Tuning Check List
Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements. You will learn about best practice configuration, SQL Server surface area, memory optimizations, isolation levels, Tempdb and transaction log configuration.