On November 4 in Seattle, I’m presenting a new pre-conference workshop!

Tuning T-SQL for SQL Server 2019 and 2022

You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans.

Your company is now using SQL Server 2019 or 2022 in production, and you want your queries to go as fast as possible. You want to know what changes to make to your existing queries in order to speed them up dramatically. You don’t want a “what’s new” session – you want practical information you can use to identify T-SQL that used to work fine in older versions, but now needs attention in newer versions.

In this 1-day session, Brent Ozar will use the same practical before-and-after techniques that he uses in his Query Challenges blog series in order to demonstrate what parts of your skills need to change as you modernize your databases.

You should be comfortable using SSMS to write multi-page queries, functions, and stored procedures. You should be comfortable identifying common query plan operators like index seeks & scans, key lookups, sorts, and parallelism, and comparing plans.

In this session, you’ll:

• Learn what kinds T-SQL should be rewritten to aim for batch mode
• Understand the effects of cardinality estimation feedback & parallelism feedback, and how to improve them
• Discover new monitoring potential in query plan DMVs to troubleshoot bad plans and blocking

Attendees will get one year free access to my Fundamentals of Query Tuning and Mastering Query Tuning classes, both of which will be updated with content from the pre-con.

Register here, and see you in Seattle!