Updated Training Modules for SQL Server 2019 & 2022
At the PASS Summit this month, I presented a 1-day workshop called T-SQL Tuning for SQL Server 2019 & 2022. I just took that material and refactored it into a few different modules for various classes:
- Mastering Server Tuning – Why Query Monitoring is Hard Now – because I see so many people making bad decisions based on the output of sp_BlitzCache, Query Store, and 3rd party monitoring tools.
- Mastering Query Tuning – T-SQL Tuning Speed Hacks for the Year 2025 – simple default options to use for databases that you’re actively tuning.
- Fundamentals of Query Tuning – Using AI for Query Tuning – in the year 2025, this won’t work as well as it looks in the ads, and I explain why, plus show how ways that I successfully use it today.
- Fundamentals of Query Tuning – Recap & Next Steps – I often refer to my work as being like a carpenter with a bunch of tools laid out in front of me. I cover the different tools at a very high level, including the order in which you should use ’em.
There are more modules to come, but I wanted to get these out the door quickly so that folks whose memberships expire this month can still sneak in. Those of y’all whose Black Friday bundles are renewing will get even more over the next couple of months. Enjoy!
Related

Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Get Free SQL Stuff
"*" indicates required fields

2 Comments. Leave new
Is this going to be available for those of us who use the “2020 or earlier” login page?
Yep, they’re already on the relevant pages in that site as well. Enjoy!