[Video] Office Hours: Off St. Thomas
I’m at sea again, this time cruising aboard the Disney Treasure off of St. Thomas. Let’s go through […]
brentozar.com
And Then There Was The Time RCSI Actually Made Query ...
Normally when I tell people about SQL Server’s optimistic concurrency isolation levels, Read Committed Snapshot Isolation (RCSI) and […]
If You Had to Go Back On-Prem… #tsql2sday
For T-SQL Tuesday #199, Koen Verbeeck posed an excellent question: if your company moved up to the cloud, […]
Today Is the Last Day of Our Anniversary Sale!
Way back in May 2002, I posted my first blog post here. I didn’t know what it would […]
[Video] Office Hours: Ask Me Anything At Home
I’m back in the home office to take another round of the top-voted questions from https://pollgab.com/room/brento. Here’s what […]
Looking Back On My 2018 Predictions
For T-SQL Tuesday #100, Adam Machanic’s challenge for SQL bloggers was to predict what databases would be like […]
Who’s Hiring Database People? June 2026 Edition
Is your company hiring for a database position as of June 2026? Do you wanna work with the […]
[Video] How to Tune Queries Fast
In this live stream recording, I’ll show you how to use the latest features of sp_BlitzCache to rapidly […]
SSMS Copilot is Messing With Your AI Prompts.
You might notice that the advice you get from Copilot in SSMS isn’t very good, but it isn’t […]
Your Database Just Hit One Terabyte: Now What?
Congratulations. You were minding your own business, and all of a sudden it happened. You glanced at file […]
[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 […]
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 […]