Black Friday prices end in 20d 17h 40m — See the sale

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.
Performance Tuning

Row-Level Security Can Slow Down Queries. Index For It.

The official Azure SQL Dev's Corner blog recently wrote about how to enable soft deletes in Azure SQL using row-level security, and it's a nice, clean, short tutorial. I like posts like that because the feature is pretty cool and accomplishes a real business goal. It's always tough deciding where to draw the line on how much to include in a blog post, so I forgive them for not including one vital caveat with this feature.

Read more about Row-Level Security Can Slow Down Queries. Index For It. 3 comments — Join the discussion

Logical Reads Aren’t Repeatable on Columnstore Indexes. (sigh)

Sometimes I really hate my job. Forever now, FOREVER, it's been a standard thing where I can say, "When you're measuring storage performance during index and query tuning, you should always use logical reads, not physical reads, because logical reads are repeatable, and physical reads aren't. Physical reads can change based on what's in cache,…

Read more about Logical Reads Aren’t Repeatable on Columnstore Indexes. (sigh) 12 comments — Join the discussion

I’m Not Gonna Waste Time Debunking Crap on LinkedIn.

LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.)

People wanna look impressive without actually putting in the work to gain real knowledge. They're asking ChatGPT to write viral "expertise" knowledge posts for them, and they're publishing this slop without so much as testing it.

Read more about I’m Not Gonna Waste Time Debunking Crap on LinkedIn. 47 comments — Join the discussion

[Video] Office Hours: Back in the Bahamas Edition

Yes, I'm back on a cruise ship with another 360 degree video. Lest you think I'm being wildly irresponsible (or responsible perhaps?) with your consulting and training money, be aware that this particular cruise was free thanks to the fine folks in the casino department at Norwegian Cruise Lines. In between beaches and blackjack, let's go through your top-voted questions from https://pollgab.com/room/brento.

Read more about [Video] Office Hours: Back in the Bahamas Edition 1 comment — Join the discussion

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