Confession Time: I Never Taught You About B-Trees.
I work with databases for a living.
I teach people, and I help them via consulting.
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.
4d 06h 59m until registration closes
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 kitNeed hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.
See consultingFresh 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…
Who’s Hiring Database People? July 2026 Edition
Is your company hiring for a database position as of July 2026? Do you wanna work with the kinds of people who read this blog? Let's make a love connection.
If your company is hiring, leave a comment. The rules:
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:
