Live online · Registration open through Nov 30
Four live class weeks of SQL Server performance tuning, with me answering questions as we go. Registration closes Nov 30; after that, it’s recordings only until next year.
6d 13h 36m Until the live classes start · Nov 2, 9 AM Pacific
$4,395
$995
Black Friday price
Live Class Season Pass 2027 · Save $3,400
Plus a Monday roundup of my favorite database news from around the web.
Find out free with sp_Blitz and the First Responder Kit — trusted by DBAs everywhere.
Download the kitNeed hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.
See consultingThe winter rotation of my live online classes starts next week:
Fundamentals Week - Nov 2-6
Mastering Index Tuning - Nov 30-Dec 4
Mastering Query Tuning - Jan 11-15
Mastering Server Tuning - Feb 8-12
This episode is entirely dedicated to just one question, and it's not a technical one. MidwestDBA asked, "When Randolph West left Microsoft, you wrote 'They're leaving MS'. While it was clearly just 1 guy leaving, not many, so 'he is leaving', not 'they are leaving'. I do think this excessive PC language fuels the far-right globally. An extreme reaction to an extreme phenomenon." Let's talk about it.
You're testing a query, and you're just not getting the same performance between the development and production servers.
There's a huge list of common things that might be causing it:
This needs to just stay between you and me, okay?
Microsoft's been working on automatically indexing SQL Server databases. No, not that Azure SQL DB feature, but one that actually works on-premises, going back through all supported versions of SQL Server. This is the brain child of Conor Cunningham and Jianjun Chen - yes, those guys, legends of the SQL Server engine, who've been hard at work on this for over two decades.
