Videos

I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Student: Hi Brent! Why is full backup sometimes slow and sometimes fast in similar situations? This problem will be resolved after restarting the server but it comes back again. 02:58…

Let’s pick up right where we left off yesterday. I’ve got more time and champagne, so let’s keep going through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Wilma: Poor code & tuning issues. Evidence = Database Performance Analyzer & sp_blitz. App is the customer’s idea. The dev has got golden…

I’m back in San Diego, so let’s sit out on the balcony, enjoy a tasty beverage, and go through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Carl: Hi Brent, what is your opinion of the graph db support starting in SQL2017? Is this another doomed SQL feature? 02:06 Bob: Brent, sometimes when…

Let’s get together at sunrise in Cabo San Lucas, Mexico and talk through your highest-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:33 AtHomeWithCOVID: Historical advice is to spread multiple datafiles/filgroups across disks. Now, storage is allocated from a balanced SAN as one drive, e.g “D” data, “L” Logs Are there any gains…

Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How to determine amount of memory (RAM) used by query store? 02:23 Aslan: Merhaba Brent, in your opinion, what are the top 4 databases to administer by DBA…

Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…

Join me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:48 md: Hi Brent, as SQL Server works with 8K pages why is the recommended NTFS Unit Allocation Size for SQL volumes 64K? Wouldn’t 8K be a more efficient fit? Sneaking in a second…

I went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit of a 2008R2 theme! https://youtu.be/3-B5L3Komq4 Here’s what we covered: 00:00 Introductions 02:00 Pete Donnelly: Hi Brent, I have a 7 TB DB and the largest table is 2 TB, has 6 indexes and 6 related Statistics. It…

Yesterday, I finished setting up my new Apple MacBook Pro with the new M1 Max processor and did its first live stream on my Twitch channel to see how the hardware held up. I was tickled pink – worked great! Here’s what we covered: 00:00 Introductions 03:48 TheGreatFode: Hi Brent, have you ever seen cases…

Not all of your questions need detailed answers. In this speed round, I race through 18 answers in 11 minutes: Here’s what we covered: 00:11 UnfortunatelyPostgresIsCheaper: I know you’ve answered that, as far as u know, there isn’t a ‘Brent Ozar’ of Postgres, but as you spend a lot of time with it u must know…

Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:22 Andrew from Canada: To Null or not to Null? That is the question. On tables with 100M to 1B rows and with several columns that contain data 20% of the time, should…

I hang out on my balcony in San Diego with a gin & tonic and a bunch of your highly upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:33 FishCakesForTea: I have designed a filtered index for a specific query but SQL Server doesn’t use it unless I move the columns in the…

I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Dylan: Do you have any experience with sys.dm_db_tuning_recommendations? To be clear, I am not referring to Azure SQL or Automatic Index Tuning, but rather Query Store Forcing/Unforcing plans automatically.…

Think fast! Not all of the questions at https://pollgab.com/room/brento have long-winded answers. In this 5-minute session, I crank through a bunch of straightforward questions: 00:00 Introductions 00:32 Mike: Hi Brent, the delete job is blocking for around 20 minutes our update or inserts calls from api which is expected to be completed with few seconds.…

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?…

It’s a beach day! Let’s hang out at Silver Strand State Beach and I’ll take your highly voted questions from https://pollgab.com/rooms/brento. Here’s what we covered: 00:00 Introductions 00:45 Dylan: Why does an UPDATE on a 2nd key column in an index (100% FF) cause a “bad” page split; the first column is 100% unique. I…

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…

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…

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…