Posts by Brent Ozar

Mastering Server Tuning

Free Webcast Tomorrow: Mastering Server Tuning

Company News
1 Comment
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching 60-90 minutes of my most popular classes for free this spring, and now it’s time for the Mastering classes. Tomorrow I’m covering Mastering Server Tuning. This class is the grand finale of all of my classes, and…
Read More
I'M MAD AS HELL AND I'M NOT ... actually I'm going to keep taking it because I get paid to take it

Fabric Is Just Plain Unreliable, and Microsoft’s Hiding It.

Microsoft Azure
29 Comments
Update 2025/07/21: Microsoft heard the complaints, and fixed the reliability added a better status page. Baby steps. Last week, Microsoft Fabric went down yet again for hours on multiple continents. Oh, you didn’t hear about it? Let’s talk about why. First, Fabric’s status page is fabricated bullshit. The link https://aka.ms/fabricsupport takes you to a localized…
Read More
[Video] Office Hours at the Hoover Dam

[Video] Office Hours at the Hoover Dam

Videos
0
Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of myself for that one. Here’s what we covered: 00:00 Start 02:20 The Princess and the Frag: On SQL Server 2019 or later, are reorganising a columnstore index and triggering the tuple mover both the same thing? I…
Read More
Predicting When SQL Server Will Hit the CPU Wall

Predicting When SQL Server Will Hit the CPU Wall

Wait Stats
12 Comments
Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to tune. However, let’s say you’ve got a really well-tuned SQL Server where: Queries finish in milliseconds (think 5-20 milliseconds, super quick) Everything your queries need is cached in memory There are no blocking issues The workload doesn’t…
Read More
SQL ConstantCare Badges

SQL ConstantCare Badges

SQL ConstantCare
7 Comments
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your servers faster and more reliable, is about to start sending out monthly awards! On the first weekday of each month, we’ll email the winners with their gold, silver, and bronze badges. Well, I say badges – some…
Read More
Mastering Query Tuning

Free Webcast Tomorrow: Mastering Query Tuning

Company News
0
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching 60-90 minutes of my most popular classes for free this spring, and now it’s time for the Mastering classes. Tomorrow I’m covering Mastering Query Tuning. This class is specifically targeted at folks who have already attended the…
Read More

[Video] Office Hours: Speed Round!

Videos
1 Comment
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 we covered: 00:00 Start 00:34 Alain Térieur: Hi Brent. I started the restore of a (big) DB. And it took more than 2h before the resore actually started. What was SQL doing all that time? And more…
Read More
Mastering Index Tuning

Free Webcast Tomorrow: Mastering Index Tuning

Company News
6 Comments
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching 60-90 minutes of my most popular classes for free this spring, and now it’s time for the Mastering classes. Tomorrow I’m covering Mastering Index Tuning. This class is specifically targeted at folks who have already attended the…
Read More

Announcing Our Anniversary Sale!

SQL Server
0
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. I couldn’t have imagined that decades later, the site would be home to: Over 3,500 blog posts with over 10,000 comments About 1,000 pages of content A mailing list with about 50,000 active subscribers A First Responder…
Read More
Hot Dog Fingers

[Video] Office Hours: Hot Dog Fingers Edition

Videos
1 Comment
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, and… it’s still pretty weird. Let’s go through your top-voted questions from https://pollgab.com/room/brento and have a laugh at my hot dog fingers. I didn’t mention in the video, but I do have to say: the audio capture…
Read More
[Video] Office Hours: Hello Kitty Porsche Edition

[Video] Office Hours: Hello Kitty Porsche Edition

Videos
0
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:56 TheWorstDBA: I have a large table with 50 billion rows. It has a partition implemented on it, with a columnstore index. SP_BlitzIndex suggest I add…
Read More

It’s Time for Fundamentals Week! Register for Tomorrow’s Classes.

Conferences and Classes
0
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and they’ve whetted your appetite for serious SQL Server learning. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watching recordings or stepping through demos yourself, but…you…
Read More
[Video] Office Hours in the Home Bar

[Video] Office Hours in the Home Bar

Videos
0
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:57 jrl: Do you have any advice about communicating effectively in a fully remote workplace where all discussion is centered around a messaging platform like Slack or Teams? The company I…
Read More