Free SQL Server help, 3× a week

Your databases are slow. My emails will fix that.

Three blog posts a week, plus a Monday roundup of my favorite database news from around the web. No fluff, occasional jokes.

Or start with the free First Responder Kit

Cartoon Brent Ozar holding a coffee mug

Recorded classes

The latest recordings are on sale now

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 classes

Live classes

The next live rotation is coming

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 consulting

Fresh from the blog

All posts
T-SQL & Development

Set Your Application Names Before You Wish You Had.

When you run monitoring queries like sp_BlitzWho and sp_WhoIsActive, you wanna see the program names that are running the queries. It's super useful when you've got multiple apps running on the same servers, or when you've got apps scattered across end user computers.

If you don't set the program names, you'll either end up with empty strings, or your dev tool's default name, like Core .Net SqlClient Data Provider, which doesn't tell you jack.

Read more about Set Your Application Names Before You Wish You Had. 9 comments — Join the discussion