[Video] Office Hours from Iceland’s Glacier Lagoon
Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple […]
brentozar.com
Who’s Hiring Database People? July 2026 Edition
Is your company hiring for a database position as of July 2026? Do you wanna work with the […]
How to Format Your Queries in SSMS
Microsoft SQL Server Management Studio 22.7 added the ability to format your T-SQL queries by right-clicking and clicking […]
Live Class Enrollment Closes July 12. Here’s Why.
Years ago, when I used to sell a Live Class Season Pass, I sold it year long. All […]
[Video] Office Hours at Iceland’s Most Famous Waterfall
Iceland has some pretty famous waterfalls, from Þórufoss and Skógafoss in Game of Thrones, to Háifoss in Stranger Things, […]
5 Reasons You Should Hire Richie Rump Today.
We’re discontinuing our apps (not the First Responder Kit scripts, just the apps), which means I’m laying off […]
Get Your Blog Posts Ready for T-SQL Tuesday #200. Here’s ...
Way back in December of 2009, Adam Machanic published a blog post (archive) in which he invited database […]
Announcing New Live Online Classes! Save 50% to Celebrate.
I used to run live online classes all year round, and I really miss it. I’ve had such […]
[Video] Office Hours in a Lava Field
On a 12-hour layover in Keflavik, I pulled over my Suzuki Jimny (love these little things, and we […]
I’m Coming to the #PassDataSummit in Seattle!
The lineup for the PASS Data Community Summit Seattle event was just released,and I’m proud to share that […]
We’re Discontinuing SQL ConstantCare and the Consultant Toolkit. Here’s Why.
About ten years ago, I sketched out an idea for a different kind of SQL Server monitoring tool: […]
[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 […]
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 […]