Launch week: the Season Pass & Fundamentals Week are 50% off — ends in 9d 06h 45mSee 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.

9d 06h 45m 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

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 8 comments — Join the discussion

[Video] Office Hours at Iceland’s Most Famous Waterfall

Iceland has some pretty famous waterfalls, from Þórufoss and Skógafoss in Game of Thrones, to Háifoss in Stranger Things, to Dettifoss in Prometheus, and more. However, probably the most-photographed one is Seljalandsfoss, partially because of its easy access from the Ring Road, and partially because of, uh, Justin Bieber's video for I'll Show You. That video is also a pretty good intro to the greatest hits of Iceland's south coast.

Read more about [Video] Office Hours at Iceland’s Most Famous Waterfall Be the first to comment