Posts by Brent Ozar

The Brent Ozar Black Friday Sale is Open Now.

Company News
1 Comment
It’s the mooooost wonderful tiiiiime of the year…. You’re a database professional who wants to up your game. You’ve been stuck at home this year, and next year isn’t looking much better. You can’t attend in-person training classes, but you desperately need the training. You’re facing bigger and bigger data problems. You’re dealing with more…
Read More

Free Webcast Coming Up: How to Size Storage for SQL

Storage
0
Storage sizing isn’t just about space: it’s about latency and throughput. When you move to new hardware or the cloud, and when you try to consolidate SQL Servers, you can’t just add up the database sizes and call it a day. Storage sizing isn’t just about space: it’s about latency and throughput. So how can…
Read More

[Video] Office Hours in Malibu: Ask Me Anything About SQL Server

Videos
5 Comments
I’m up bright and early in Malibu, so let’s talk through your highly upvoted questions from https://pollgab.com/room/brento. 00:00 Introduction 01:04 JD: Have you ever encountered a very weird case during query / performance tuning that you just couldn’t get the query across the finish line, specifically just because SQL Server didn’t want to behave nicely?…
Read More

Announcing My 2021 Black Friday Sale Bundles

Company News
17 Comments
You’re a database professional who wants to up your game. You’ve been stuck at home this year, and next year isn’t looking much better. You can’t attend in-person training classes, but you desperately need the training. You’re facing bigger and bigger data problems. You’re dealing with more and more queries. The queries are getting more…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server

Videos
2 Comments
It’s time for the first live Office Hours in my new home studio in San Diego! I took your highest-upvoted questions from https://pollgab.com/room/brento/ and answered ’em: Here’s what we covered: 00:00 Welcome 01:30 Accidental DBA: Hi Brent, do you have a recommended checklist for trubleshooting occasional slow INSERT performance? 03:19 Mark: How do companies deal…
Read More

Behind-the-Scenes Home Studio Tour

Videos
13 Comments
Whenever I move to a new place and set up a new home studio, I give you a walkthrough so you can get a rough idea of how I work. I just finished setting up my new San Diego home base, and here’s a tour of what it looks like both as an attendee, and…
Read More

I’m Not Ready for Maskless Conferences Serving Finger Food.

At a conference in Belgium this week, Steve Jones posted a video: A real conference experience. Excellent crowd at @datamindsbe pic.twitter.com/TGZmw5PdmC — way0utwest ?? (He/Him/His) (@way0utwest) October 11, 2021 My first reaction was, “That’s an awful lot of people in really close proximity, talking loudly at each other, and none of them are wearing masks.”…
Read More

[Video] Office Hours: Ask Me Anything On the Balcony

Videos
5 Comments
Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:27 Alex: Hi Brent. For a few hours we got a “Could not continue scan with NOLOCK due…
Read More

Free Classes Start Next Week. Register Now.

Company News
8 Comments
This month & next, I’m going to teach you the fundamentals of SQL Server database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fall I’m updating and expanding it to a 3-hour version.…
Read More

[Video] Office Hours in My New San Diego Apartment

Videos
1 Comment
Just got the keys to the new home base in San Diego, and the furniture isn’t even in yet. I went through your top-voted questions from https://pollgab.com/room/brento before my smoke alarm battery started chirping: Here’s what we covered: 00:00 Introductions 01:10 Yoni – We have 60-100GB DBs on SQL server on windows (VM). Will it…
Read More
Menu