Predicting When SQL Server Will Hit the CPU Wall
Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to […]
brentozar.com
SQL ConstantCare Badges
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your […]
Free Webcast Tomorrow: Mastering Query Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
[Video] Office Hours: Speed Round!
Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round: Here’s what […]
Don’t Let Your Kids Drop ACID.
We’re heading towards graduation time. In just a few short months, your high school kids are going to […]
Who’s Hiring in the Microsoft Data Platform Community? May 2025 ...
Is your company hiring for a database position as of May 2025? Do you wanna work with the […]
Free Webcast Tomorrow: Mastering Index Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
Announcing Our Anniversary Sale!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
[Video] Office Hours: Hot Dog Fingers Edition
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, […]
SQL Server 2022 Finally Fixed a SQL Server 2008 Query ...
For yeeeeeears, when I’ve explained execution plans, part of my explanation has included the instructions, “Read the plan […]
[Video] Office Hours: Hello Kitty Porsche Edition
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer […]
Building AI Calls into the First Responder Kit
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your […]
It’s Time for Fundamentals Week! Register for Tomorrow’s Classes.
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and […]
[Video] Office Hours in the Home Bar
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. […]
Your SQL Server Needs Spring Cleaning, Too.
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside […]
Updated First Responder Kit and Consultant Toolkit for April 2025
This quarter’s release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about […]
The Waitlist is Open Now for My SQLBits Workshop!
I’m excited to return to London for SQLBits again this year! I’ve written about why SQLBits is my […]
[Video] Office Hours in North Bay, Canada
Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I […]
Tap Tap Tap – Short, Silent SQL Server Tutorials
One of the things I love about TikTok is that it exposes me to wildly new video ideas […]
Free Webcast: Avoiding Deadlocks by Query Tuning
Deadlocks used to scare me. I’d get the alert from a monitoring tool, and I’d look around to […]
Free Webcast Tomorrow: Fundamentals of Columnstore
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Fundamentals Week 2025 is Coming This Month! Get Your Tickets ...
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Free Webcast Tomorrow: Fundamentals of TempDB
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
[Video] Office Hours: Back in the Home Office
I’m back home after a 2-week Iceland vacation. Let’s catch up with your top-voted questions from https://pollgab.com/room/brento. Here’s […]
Query Exercise Answer: Finding Email Addresses
For this week’s Query Exercise, your mission had two parts: Do a first pass search through the Users […]
Why Your Azure SQL DB Hyperscale Bill is Higher Than ...
tl;dr: if you use Azure SQL DB Hyperscale’s auto-scaling, it’s probably not cutting your bill down because like […]
[Video] Office Hours: Waiting for the Hot Tub to Fill
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s […]
T-SQL Has Regex. Don’t Get Too Excited.
Regular expressions are a way of doing complex string searches. They can be really useful, but they have […]
Query Exercise: Looking for Email Addresses
“They put their password WHERE?!?” Personally identifiable information (PII) is freakin’ everywhere. When companies first start looking to […]
Free Webcast Tomorrow: Fundamentals of Query Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
What’s Coming in SQL Server 2025, DMV Edition
As we approach the first public releases of SQL Server 2025, it’s fun to start spelunking through things […]
Announcing Fundamentals Week 2025!
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Free Webcast Tomorrow: Fundamentals of Index Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
[Video] Office Hours: Philosophical Questions at the Waterfall of the ...
I’m in Iceland this week, land of fire and ice, a place I keep coming back to over […]
Free SQL Server Spring Training Live Webcasts Start Next Week.
Starting next Tuesday, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
Who’s Hiring in the Microsoft Data Platform Community? March 2025 ...
Is your company hiring for a database position as of March 2025? Do you wanna work with the […]
Office Hours: Unusual Beach Chair Edition
When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on […]
Finding Out What Changed in a Cumulative Update
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We […]
Vertical Partitioning Is Almost Never the Answer. Here’s Why.
You’re looking at a wide table with 100-200 columns. Years ago, it started as a “normal” table with […]
[Video] Office Hours: We’ve Got the (Honda) Beat
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. […]
Why I Mention My Sexuality and Gender
I certainly don’t discuss it often, and it’s been a few years since I wrote about my pansexuality. […]
I’m Doing Free SQL Server Spring Training Live Webcasts. Register ...
Starting next month, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
[Video] Office Hours: Hawaiian Edition
I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in […]
I’m coming to Jacksonville and Raleigh for SQL Saturday! Register ...
I’m coming to Jacksonville, FL on May 2-3 and Raleigh, NC on May 16-17 for SQL Saturdays! In […]
The 8 Worst Things Microsoft Ever Did to SQL Server
Last week I wrote about the 6 best things Microsoft ever did to SQL Server, but now we […]
SQL ConstantCare® Population Report: Winter 2025
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. […]
Who’s Hiring in the Microsoft Data Platform Community? February 2025 ...
Is your company hiring for a database position as of February 2025? Do you wanna work with the […]
The 6 Best Things Microsoft Ever Did to SQL Server
This entire blog post is driven by the #1 feature in this list. I think about the #1 […]
[Video] Office Hours and an AI-Generated Sweatshirt
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use […]
Index Rebuilds Make Even Less Sense with ADR & RCSI.
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works. […]