Thoughts on AI After My Panel Discussion
Today at Day of Data Orlando, I moderated a panel discussion with Bob Ward, Celia Brusatori, Kevin Feasel, […]
brentozar.com
[Video] Office Hours on the Last Alaskan Cruise of the ...
It’s a cold, gloomy day on the very last Alaskan cruise of the season. Yes, I picked this […]
Breaking News: Hold Off on SSMS 22.11.0
There’s a new SQL Server Management Studio update out today. I’d hold off on it for now. I […]
Fact-Checking Microsoft’s “PostgreSQL to SQL Field Notes: Connections”
Microsoft has started a series of blog posts helping Postgres developers who are “upgrading” to Microsoft SQL. (Microsoft’s […]
Free Webcast: How to Think Like the SQL Server & ...
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re […]
Heads Up: SQL Server 2017 Support Ends One Year From ...
Tick tock. SQL Server 2017 extended support ends on October 12, 2027. That means today, you need to […]
[Video] A Very Special Episode of Office Hours
When we were kids, we knew we were in for something heavy whenever a TV series began an […]
Who’s Hiring Database People? October 2026 Edition
Is your company hiring for a database position as of October 2026? Do you wanna work with the […]
Your queries are slow. Let’s make your training request fast.
You wanna take my SQL Server classes. Your boss wants to know what they cost, when you’ll be […]
When You Work with AI, You’re a Middle Manager.
I got my start in hotels & restaurants, worked my way up to being a hotel general manager, […]
Registration Is Open Now! $995 for a 2027 Live Class ...
I teach Microsoft SQL Server performance tuning in a 4-class rotation. The winter rotation is getting ready to […]
I’m Just Gonna Leave This Here
Sometimes my value as a blogger is to make complex topics simple, or to deliver industry news to […]
So, What’s New Lately in My SQL Server Training Classes?
On Wednesday, registration opens for the next round of my live training classes, and you can get access […]
[Video] Office Hours Off the Coast of Long Beach
A couple times a year, I go away for a week to think about what’s working well, what […]
Announcing a New Way to Reinforce Your Resume: My Alumni ...
I hope you never have to look for another job. However, if you do, I wanna give you […]
Database Animations: Stop Using Page Splits to Justify Lowering Fill ...
You’re looking at page split numbers in a monitoring tool or Perfmon, and you’ve heard that page splits […]
Join Me at Day of Data Orlando Next Month
Next month on Saturday, October 17, I’ll be speaking at the free Day of Data Orlando. Registration is […]
[Video] Office Hours: Open Q&A for Microsoft Databases
Today I’m back in the home office, finishing up teaching Mastering Index Tuning and getting ready to head […]
Live Class Enrollment Opens Soon – For Just $995!
I teach Microsoft SQL Server performance tuning in a 4-class rotation. The winter rotation is getting ready to […]
“But NOLOCK won’t hurt me if I’m using an index!”
NOLOCK is bad and you probably shouldn’t use it, but every time I mention that publicly, the pushback […]
[Video] Office Hours on Mount Charleston
For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the […]
Database Animations: How SQL Server’s JSON Indexes Work
By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to […]
Set Your Application Names Before You Wish You Had.
When you run monitoring queries like sp_BlitzWho and sp_WhoIsActive, you wanna see the program names that are running […]
[Video] Office Hours: Stoicism in the Home Office
I’m back in the home office this week, covering your top-voted questions from https://pollgab.com/room/brento, and we finish up […]
Who’s Hiring Database People? September 2026 Edition
Is your company hiring for a database position as of September 2026? Do you wanna work with the […]
Free Webcast: You Shouldn’t Use SQL Agent for Batch Processes.
SQL Server Agent is a solid scheduler for database administration and simple, database-local automation. In a small to […]
How to Download the Stack Overflow Database for Postgres
You wanna learn PostgreSQL, and you wanna use a sample database with big real-world data, the same kinds […]
It’s Been 10 Years. Has Microsoft Built What You Voted ...
Ten years ago, I published a blog post with the top 10 most highly upvoted requests for Microsoft […]
sp_TexasHoldEm: Multi-Player Poker in T-SQL
Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other […]
Database Animations: The Difference Between Row Compression and Page Compression
What’s the difference between SQL Server’s row compression and page compression, and when does each one make sense? […]
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 […]
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 […]