The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been selected for a general session!

Watch Brent Tune a Query in SQL Server 2022: Ever wonder how somebody else does it? In this all-demo session, watch over Brent Ozar’s shoulder while he takes a slow stored procedure in the Stack Overflow database, analyzes it, and iterates over several improvements trying to make it go faster. He’ll explain his thought process as he goes, and get feedback from the audience on what they’d try as well.

Goals:

• Learn to use sp_BlitzCache to identify which queries in a proc need tuning first
• Understand the use of query hints to test possible database setting changes
• See how to measure the overhead of query hints like recompiles

Prerequisites: You should be comfortable writing T-SQL, reading execution plans, and using STATISTICS IO to measure logical reads.

Register now because discounted early bird registration prices are available til July 9th:

• 3-day conference ticket $1,895: includes the Weds/Thurs/Fri general sessions like mine above
• Use referral code BRENTO24 for another $150 off that 3-day price
• Pre-conference workshops: $595 each, like my Tuning T-SQL for SQL Server 2019 and 2022 on Monday

See you in Seattle!