You know how you're trying to use SQL Server Management Studio to tune performance? There's a new Performance Studio instead from Erik Darling: github.com/erikdarlingd... In its infancy, it already looks pretty useful and more relevant than SSMS (again, for query tuning only though - not managing.)
Live streaming now to work on First Responder Kit pull requests: www.twitch.tv/brentozar
well, that's good, the first step is admitting that you have a problem - maybe you should talk to Copilot, buddy
Thankfully, the robots are taking over, and they don't need accurate data to do their jobs.
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,…
Reading: The Great Happiness Compression, measuring how American happiness dropped across the board after COVID. homeeconomics.substack.com/p/the-great-...
For 3 years now, using SESSION_CONTEXT in SQL Server has either given you incorrect results, crashes, or single-threaded queries, depending on which workaround you pick: www.sqlfingers.com/2026/03/sess...
Yep, it is that bad. It’s frustrating to see the bad knowledge gaining traction.
ah, the days of trolling people with fake broadcast messages learn.microsoft.com/en-us/sql/da...
"WHEN I WAS YOUR AGE, I PUSHED MY SEARCH ENGINE OPTIMIZATION TO GOOGLE EVERY DAY, IN THE SNOW, UPHILL, BOTH WAYS"
It's unbelievable how much of that crap is out there, and the more accessible AI tools become, the more "contributors" we're going to see.
just reading the documentation for SQL Server's super-cool, AI-friendly vector indexes learn.microsoft.com/en-us/sql/t-...
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…
If you already knew there was a connection between those two, I love you even more, but if you didn't: en.wikipedia.org/wiki/Philip_...
People ask me all the time, "Brent - who do YOU turn to for advice?" And the answer is simple: www.youtube.com/watch?v=QmT1...
From the not-so-good news department: Hugo Kornelis' leukemia has returned: sqlserverfast.com/blog/hugo/20...
Why would you use Microsoft SQL Server over Postgres? Well, Postgres guru Bruce Momjian has a good presentation of features that are still missing, and it's fair and open: momjian.us/main/writing... Most of that stuff is already built into MSSQL.
[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…
Looking for a Microsoft SQL Server or Azure SQL DB job? There are a handful posted in the comments right now: www.brentozar.com/archive/2026...
Intriguing topic for next week's T-SQL Tuesday: What Career Risks Have You Taken? www.jamesserra.com/archive/2026... I'm heading out to Canada to meet up with friends for a curling tournament, so I can't post in time though.
facebook ads really gets me orbitalclothingbrand.com/products/i-l...
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 kinds of people who read this blog? Let's make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job…
walking through the office the morning after a long unplanned outage
I’ve Been Using Macs for 20 Years. Here’s What You Wanted to Know.
tl;dr - It's easier because I've always chosen to run SQL Server VMs, so it was easier for me to switch than you might expect - but if you're a Microsoft IT pro, I don't recommend switching. Now for the long version. About 20 years…
when they describe multiple instances of SQL Server on the same VM
Fortune 500 company relying on an app where they've lost the source code, that's supposed to be running on Oracle, but it's running on a 15-year old version of Postgres... ah, good times vonng.com/en/pg/ivorys...
Dang it, where did you get that? Is there a group text I’m not on?
Ohio?!!
Oh. I don’t know if I’ve ever actually come out publicly, SQL people.
Yeah, I’m pansexual (and juuuuuust a smidge genderqueer).
No, not kidding.
Yes, it took me a LONG-ASS TIME to figure that out.
So, yeah. I thought y’all might maybe oughta know.
(Waves cheerily at @brento.bsky.social.)
