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 […]
brentozar.com
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. […]
What If You Need to Index a Lot of Duplicate ...
Let’s get a little nerdy and look at database internals. Create two tables: one with a million unique […]
[Video] Office Hours in My Vegas Backyard
I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second […]
Can AI Rewrite Bad Queries in Seconds? Kinda.
When I see horrific code, stuff that would take a lot of manual labor to fix, I like […]
Pop Quiz, 2025 Edition: What Do These Things Cost Today?
Price check on Aisle 2025. My main consulting job is a 2-day SQL Critical Care® where I help […]
I’m Coming to Croatia!
A few things lined up perfectly for a European trip this summer. I’m on a European cruise in […]
Does Separating Data and Log Files Make Your Server Faster?
I’ve already explained that no, it doesn’t make your database server more reliable – and in fact, it’s […]
Announcing the 2025 Data Professional Salary Survey Results.
We’ve been running our annual Data Professional Salary Survey for almost a decade, and I was really curious […]
[Video] Office Hours: Long Answers Edition
Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: […]
I Feel Sorry for Untrained Developers Using Entity Framework.
Most of the time, I love Entity Framework, and ORMs in general. These tools make it easier for […]
Who’s Hiring in the Microsoft Data Platform Community? January 2025 ...
Is your company hiring for a database position as of January 2025? Do you wanna work with the […]
[Video] Office Hours in Tokyo, Japan
For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on […]