[Video] How to Tune Indexes Fast
In this 76-minute session, I’ll show you how to use the latest features of sp_BlitzIndex to rapidly improve […]
brentozar.com
I Hate The Way You’re Using “It Depends.”
Can I be honest with you for a second? It makes my skin crawl when I hear database […]
Announcing the SSMS StatisticsParser Extension
If you do a lot of query tuning, you’ve probably come across Richie Rump’s StatisticsParser.com. Now, it’s even […]
[Video] Office Hours in Port
Our cruise ship pulled into port in Victoria, Canada, so before we head out to the Butchart Gardens, […]
Turns Out DBAs Use the Consultant Toolkit, Too
When I first hired Richie over a decade ago, the very first task I assigned him was to […]
New Official Documentation on Forced Parameterization
I love me some documentation. For years, I’ve pointed folks to the SQL Server 2008 documentation on Forced […]
It’s Our Anniversary! Let’s Have a Sale!
Way back in May 2002, I posted my first blog post here. I didn’t know what it would […]
“We want to archive, but we still want to query ...
At least once a month, I get this question from a client: We have big data, and we […]
Free SQL Server Spring Training on Performance Tuning
Times and tech are changing quickly. Let’s get you up to speed on the latest developments to do […]
Who’s Hiring Database People? May 2026 Edition
Is your company hiring for a database position as of May 2026? Do you wanna work with the […]
Free Webcast: Fixing Parameter Sniffing with Index Tuning
When a query is sometimes fast and sometimes slow, there are a lot of ways you can reduce […]
So You Wanna Build an App
I get a lot of emails like this: Hi! I built an app. Can you take a look […]
You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.
When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually […]
There Are Days When I Feel Like Giving Up on ...
In theory, SQL Server performance monitoring is pretty simple: Review the server’s top wait types Find the queries […]
Contest Winners: Make the Comments Look Like My ChatGPT History.
I asked y’all to make the comments on this post look like my ChatGPT history, and y’all understood […]
SQL ConstantCare® Population Report: Spring 2026
It’s time for our quarterly update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks […]
There’s a Bug in sys.dm_exec_query_plan_stats.
When you turn on last actual plans in SQL Server 2019 and newer: ALTER DATABASE SCOPED CONFIGURATION SET […]
Building My Dev/Prod Demon Hunters Session, Part 2: The Tactics
This week at the SQLBits conference in Newport, I’m teaching an all-new all-day session called Dev-Prod Demon Hunters: […]
Updated First Responder Kit and Consultant Toolkit for April 2026
If there was ever a release you should skip for reliability reasons, it’s this one. There’s a lot […]
Announcing the Panel Lineup for My SQLBits Cloud Discussion
At SQLBits, I’m hosting a panel discussion called 20 Years of the Cloud: What Changed, What Didn’t, and […]
SQL Server 2016 Support Ends in 90 Days.
On July 14, 2026, Microsoft’s extended support ends for SQL Server 2016. Brent Ozar Unlimited circa 2016 They […]
Announcing More Improvements to PasteThePlan.com
Need to share an execution plan, like on forums or on Stack Overflow, and you wanna get their […]
SQLBits Bonus: Free Fundamentals + Mastering Bundle for My Training ...
Good news! My training day workshop, Dev/Prod Demon Hunters, was sold out, but Bits just moved me into […]
[Video] Office Hours: Microsoft Database Q&A
Let’s go through a LOT of your top-voted questions from https://pollgab.com/room/brento on a VERY early Saturday morning. 00:00 […]
Contest: Make the Comments Look Like My ChatGPT History.
Let’s have some fun. Put yourself in the frame of mind of the fella who writes this blog. […]
How Multi-Column Statistics Work
The short answer: in the real world, only the first column works. When SQL Server needs data about […]
Who’s Hiring Database People? April 2026 Edition
Is your company hiring for a database position as of April 2026? Do you wanna work with the […]
SQL Server 2025 CU4 Adds Automatic Updates
Big news for everyone who has to manage Microsoft SQL Server, whether they’re DBAs, sysadmins, or developers. Seven […]
How to Draw Line Graphs in SSMS
Ever just need a quick visualization of some numbers to get a rough idea of the trend, like […]
I’m Coming to the PASS Summit in Frankfurt!
The pre-conference lineup for the PASS Data Community Summit Frankfurt event was just released, and I’m proud to […]
[Video] Office Hours: Q&A on the Mountaintop
Well, maybe mountain is a bit of a strong word, but it’s one of the highest elevation home sites […]
Y’all Are Getting Good Free AI Advice from PasteThePlan.
PasteThePlan has a new AI Suggestions tab, and it’s been really fun to watch the query plans come […]
My Wish List for SQL Server Performance Features
There are a lot of shopping days left before Christmas, and even more before the next version of […]
SSMS v22.4.1: Copilot is GA. So What’s It Do Right ...
Copilot in SSMS has two parts. Usually people focus on the pop-out Copilot chat window, and that’s useful […]
[Video] Office Hours in North Bay, Ontario
I’m up in North Bay, Ontario, Canada for the 2026 Can-Am Curling Cup run by Aaron Bertrand – […]
Updated First Responder Kit and Consultant Toolkit for March 2026
For the last few years, I’ve slowed the First Responder Kit release down to once per quarter. It […]
Get Free AI Query Advice in PasteThePlan.
At PasteThePlan.com, you can paste execution plans into your browser, then send a link to someone else to […]
[Video] Office Hours, Standing in the Ocean Edition
My tripod is probably never gonna recover from the salt water, but the water was so nice that […]
Using Claude Code with SQL Server and Azure SQL DB
Let’s start with a 7-minute demo video – I didn’t edit this down because I want you to […]
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 […]
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, […]
[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 […]
Who’s Hiring Database People? March 2026 Edition
Is your company hiring for a database position as of March 2026? Do you wanna work with the […]
The Tech Consulting Market Isn’t Looking Good.
After hearing the same dire news from several of my consulting friends, I put a poll up on […]
[Video] Office Hours in the Vegas Home Office
Let’s hang out in my home office in Vegas and go through your top-voted questions from https://pollgab.com/room/brento. The […]
I Don’t Take Private Questions at Pre-Conference Classes.
When I first started teaching database sessions at conferences, I noticed a pattern. When I finished the session, […]
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 […]
[Video] Office Hours: Ask Me Anything About Microsoft SQL Server ...
Want to ask your own questions or pick the ones I discuss? Head over to https://pollgab.com/room/brento to get […]
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 […]
[Video] Office Hours at Atlantis, Bahamas
It’s an overcast afternoon at Atlantis Paradise Island in the Bahamas, so since I can’t go into the […]