Updated Training Modules for SQL Server 2019 & 2022

Execution Plans
2 Comments

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!

Previous Post
3 Legit Signs It’s Time for Enterprise Edition
Next Post
[Video] Office Hours: Ask Me Database Questions

2 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.