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 […]
brentozar.com
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 […]
Your Favorite Blog Posts & Videos from 2024
The year is coming to a close, so it’s time to look back on your favorite stuff from […]
Updated First Responder Kit and Consultant Toolkit for December 2024
If there was ever a release you could skip, this is probably the one, because you could count […]
Working Today? Take a Break to Fill Out the Annual ...
Working today? You’re not alone. As a small business person, I tend to find myself working on emails, […]
[Video] Office Hours in Kyoto, Japan
My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the […]
The Ebb and Flow of AI
It’s the end of the year. Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, […]
[Video] Office Hours in Osaka, Japan
Kon’nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host […]
How to Explain What We Do
One of my favorite uses for AI is to ask it to explain a concept using wildly unusual […]
Are You Underpaid? Let’s Find Out! My Annual Salary Survey ...
Every year, I run a salary survey to help folks have better discussions with their managers about salaries, […]
How to Use Github in SSMS v21
SQL Server Management Studio v21 added native Git support, making it easier to use source control natively inside […]
[Video] Office Hours in Zhengzhou, China
For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to […]