Launch week: the Season Pass & Fundamentals Week are 50% off — ends in 7d 05h 11mSee the sale

FALL 2026 ROTATION · Live online

Live classes are back.

Four live class weeks, each running twice — fall and winter rotations, July through February — on one Season Pass. When registration closes, that's it until next year.

7d 05h 11m until registration closes

Cartoon Brent Ozar pointing both index fingers

3 posts a week, in your inbox

Plus a Monday roundup of my favorite database news from around the web.

Is your SQL Server okay?

Find out free with sp_Blitz and the First Responder Kit — trusted by DBAs everywhere.

Download the kit

Need hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.

See consulting

Fresh from the blog

All posts

[Video] Office Hours from Iceland’s Glacier Lagoon

Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are sold. One of my most favorite spots on earth is Jökulsárlón and Diamond Beach. The glacier Vatnajokull is slowly melting into the sea, and pieces…

Read more about [Video] Office Hours from Iceland’s Glacier Lagoon 5 comments — Join the discussion

How to Format Your Queries in SSMS

Microsoft SQL Server Management Studio 22.7 added the ability to format your T-SQL queries by right-clicking and clicking Format SQL, or by hitting control-K, control-Q on your keyboard:

You're probably not going to like the default formatting out of the box because you're the kind of person who has strong, passionate feelings and likes to argue about them on the Internet. Good news! The configurations are really flexible. Go into Tools, Options, SQL Formatter:

Read more about How to Format Your Queries in SSMS 10 comments — Join the discussion