Free SQL Server help, 3× a week
Three blog posts a week, plus a Monday roundup of my favorite database news from around the web. No fluff, occasional jokes.
Recorded classes
The Fundamentals of Index Tuning, Query Tuning, and Server Tuning have all been updated as of July 2026, reflecting the latest advancements in the First Responder Kit, AI, and SQL Server 2025. They're perfect for folks who have never been to a formal training class, but are responsible for performance on SQL Server, Azure SQL DB, and Amazon RDS.
Browse the classesLive classes
Get first dibs (and the early-bird price) the moment registration opens.
Need hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.
See consultingToday I'm back in the home office, finishing up teaching Mastering Index Tuning and getting ready to head out on a Mexico cruise. Let's go through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=JQWMdAsL4Dc
I teach Microsoft SQL Server performance tuning in a 4-class rotation. The winter rotation is getting ready to start:
Fundamentals Week - November 2-6
Mastering Index Tuning - November 30-Dec 4
Mastering Query Tuning - January 11-15, 2027
Mastering Server Tuning - February 8-12, 2027
NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK.
Today's misconception comes from a LinkedIn commenter telling me it's safe to use if you're doing index seeks. Hoo boy. Let's whip up a table with an index:
For this episode, I'm up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the weekend at Mount Charleston. Let's go through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=GN31TnYVdgI
