Live registration reopens October 1, 2026, in 7d 07h 41mNotify me

Author: Brent Ozar

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I'm based out of Las Vegas. He/him.

10 Signs It Was Time to Hire Me

You've been reading my blog, watching my videos, and maybe even taking some of my training classes. You've heard me say things like "my clients" from time to time, and you're wondering... why do companies actually hire me? What problem are they trying to solve?

Well, when clients meet with me for the first time, I have a series of questions I put up on the screen for them to talk through:

Read more about 10 Signs It Was Time to Hire Me Be the first to comment

How to Help Copilot Encourage Good Database Standards

I know a lot of y'all lag behind on upgrading SSMS, but v22.3 just introduced something that you need to be aware of. It's going to impact any of your users who DO upgrade their SSMS, or who use Github Copilot. There's something that you can do in order to improve Copilot's code quality and make it match your preferred coding standards.

Read more about How to Help Copilot Encourage Good Database Standards 17 comments — Join the discussion

Updated First Responder Kit and Consultant Toolkit for February 2026

Two big sets of news this month! The Consultant Toolkit now supports imports to a database so you can track your clients' health and performance over time, and sp_BlitzCache has a new @AI parameter.

Set @AI = 2, and get a prompt you can copy/paste into the AI of your choice to help you tune the query.
Set @AI = 1, and we'll actually call ChatGPT or Google Gemini for you and return the advice.

Read more about Updated First Responder Kit and Consultant Toolkit for February 2026 10 comments — Join the discussion
Career & Community

Building My Dev/Prod Demon Hunters Session, Part 1: The Strategy

For SQLBits this year, I wanted to submit a performance tuning session about one of the most classic, timeless problems I run into: why is the same query fast in development but slow in production?

All of my regular readers - if there is such a thing - are now yelling out, "Parameter sniffing!"

Read more about Building My Dev/Prod Demon Hunters Session, Part 1: The Strategy 10 comments — Join the discussion

I Just Don’t Understand Why You Don’t Update SSMS.

A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.

Back then, upgrading SSMS was not only a technical problem, but a political one too. Organizations would say things like, "Sorry, we haven't certified that cool new SQL Server 1982 here yet, so you can't have access to the installer." Developers and DBAs were forced to run SSMS from whatever ancient legacy version of SQL Server that their company had certified.

Read more about I Just Don’t Understand Why You Don’t Update SSMS. 42 comments — Join the discussion

Automatic Stats Updates Don’t Always Invalidate Cached Plans

Normally, when SQL Server updates statistics on an object, it invalidates the cached plans that rely on that statistic as well. That's why you'll see recompiles happen after stats updates: SQL Server knows the stats have changed, so it's a good time to build new execution plans based on the changes in the data.

However, updates to system-created stats don't necessarily cause plan recompiles.

Read more about Automatic Stats Updates Don’t Always Invalidate Cached Plans 9 comments — Join the discussion
Production DBA

Maybe You Shouldn’t Even Be Using Clustering or AGs.

Sandra Delany (LinkedIn) wrote a well-thought-out blog post called, "Should a SQL Server DBA Know Windows Clustering?" She's got about 20 years of DBA experience, and she works for Straight Path (a firm I respect) as a consultant. You can probably guess based on her background that yes, she believes you should know how to set up, configure, and troubleshoot Windows clustering. It's a good post, and you should read it.

Read more about Maybe You Shouldn’t Even Be Using Clustering or AGs. 18 comments — Join the discussion

Thoughts on PASS’s Bankruptcy, Redgate’s Acquisition, and Private Equity

A private equity (PE) company recently acquired the majority of Redgate Software, the current owners of the PASS Data Community Summit and SQLServerCentral. Everybody in tech has private equity stories, some good, some terribad. Private equity hands money to companies not out of generosity, but because they believe they can turn it into even more money…

Read more about Thoughts on PASS’s Bankruptcy, Redgate’s Acquisition, and Private Equity 36 comments — Join the discussion

[Video] Office Hours in Kyoto, Japan

Kyoto feels like a timeless, classic version of historical Japan with quiet tree-lined streets, giant temples, and bubbling brooks. It's the exact opposite of last week's experience in noisy Osaka! Last year, I filmed in Kyoto outside a temple, and this year, I'm at another temple just after New Year's, the time when Japanese folks traditionally go to visit their many gorgeous temples.

Read more about [Video] Office Hours in Kyoto, Japan 3 comments — Join the discussion