Testing AI with an Office Hours Question
When the new MiniMax H3 image-to-video model dropped this month, I was really impressed with how quickly and […]
brentozar.com
When CTEs Don’t Work, Try Temp Tables – #TSQL2sday
Common Table Expressions are awesome because they let SQL Server reorder processing in whatever way it deems to […]
[Video] Office Hours: Car in the House Edition
Today I’m hanging out in the dining room, or what would normally be a dining room, but we […]
Who’s Hiring Database People? August 2026 Edition
Is your company hiring for a database position as of August 2026? Do you wanna work with the […]
Free Webcast: 3 Numbers Every Tuner Should Know.
Every SQL Server performance tuner eventually faces the same question: is this normal, or is something wrong? The […]
[Video] Office Hours: Desert Database Q&A
I’m in the Lake Mead National Recreation Area today, hanging out in the triple-digit heat, to answer your […]
Miscellaneous Thoughts About Building Stuff with AI in July 2026
Over the past couple of years, I’ve been using the bejeezus out of AI. I don’t really feel […]
Need a Reference Check on Richie Rump? Here You Go.
So your company read my post about 5 reasons you should hire Richie Rump, and you checked out […]
Think You Know A Lot About SQL Server? Well, Actually…
Got a few minutes? Close that dating app and pay attention. Check out this little SQL swipe quiz: […]
T-SQL Tuesday Roundup: You Know A Query’s Gonna Be Bad ...
For this month’s T-SQL Tuesday, I invited y’all to tell me how you know a query’s gonna be […]
[Video] What AI is Good For Right Now
This isn’t specifically database-related, but it’s the kind of thing I’m really into, so maybe you’re into it […]
[Video] Office Hours Overlooking Rome
I was in Rome to attend a teaching conference, and my AirBnB had the most beautiful view overlooking […]
Updated First Responder Kit and Consultant Toolkit for July 2026
From now on, I’m going to be releasing annual versions of the First Responder Kit, starting with this […]
Tomorrow’s the Last Day to Sign Up!
Tomorrow’s your last day to join about a dozen of your closest friends – well, you’re gonna be […]
[Video] Office Hours at the Black Pebble Beach
After the PASS Data Community Summit in Frankfurt, Germany, I headed back to Iceland and spent a few […]
I Know a Query’s Gonna Be Bad When… #TSQL2sday
I open it up and the first thing I see is a comment with a changelog showing a […]
Confession Time: I Never Taught You About B-Trees.
I work with databases for a living. I teach people, and I help them via consulting. And as […]
[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 […]
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 […]