Videos

I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube 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…

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. Office Hours: More Of Your Questions, More ChampagneWatch this video on YouTube Here’s what we covered: 00:00 Introductions 00:39 Wilma: Poor code & tuning issues. Evidence = Database Performance Analyzer…

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. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube Here’s what we covered: 00:00 Carl: Hi Brent, what is your opinion of the graph db support starting in…

Let’s get together at sunrise in Cabo San Lucas, Mexico and talk through your highest-upvoted questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube 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…

Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: Office Hours: SQL Server at Sunset in CaboWatch this video on YouTube 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…

Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Office Hours: SQL Server Q&A at Dawn in CaboWatch this video on YouTube 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…

Join me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento. Office Hours: First Post From Cabo San LucasWatch this video on YouTube 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…

I went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit of a 2008R2 theme! Office Hours, SQL Server 2008R2 Edition, I GuessWatch this video on YouTube Here’s what we covered: 00:00 Introductions 02:00 Pete Donnelly: Hi Brent, I have a 7 TB DB and the largest table…

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! Office Hours, Black Friday Edition: Ask Me Anything About SQL ServerWatch this video on YouTube…

Not all of your questions need detailed answers. In this speed round, I race through 18 answers in 11 minutes: Office Hours Speed Round!Watch this video on YouTube 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…

Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento. Office Hours on the Balcony Part 2: Ask Me Anything About SQL ServerWatch this video on YouTube 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…

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. Office Hours on the Balcony Part 1: Ask Me Anything About SQL ServerWatch this video on YouTube Here’s what we covered: 00:00 Introductions 01:33 FishCakesForTea: I have designed a filtered index…

I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento. Office Hours, Manhattan Edition: Ask Me Anything About SQL ServerWatch this video on YouTube 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…

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: Office Hours Speed Round: Quick Questions About SQL ServerWatch this video on YouTube 00:00 Introductions 00:32 Mike: Hi Brent, the delete job is blocking for around 20 minutes our update or…

I’m up bright and early in Malibu, so let’s talk through your highly upvoted questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything About SQL Server in MalibuWatch this video on YouTube 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…

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. Office Hours: Ask Me Anything About SQL Server at Silver Strand BeachWatch this video on YouTube Here’s what we covered: 00:00 Introductions 00:45 Dylan: Why does an UPDATE on a 2nd key column in…

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: Office Hours: Ask Me Anything About Microsoft SQL ServerWatch this video on YouTube Here’s what we covered: 00:00 Welcome 01:30 Accidental DBA: Hi Brent, do you have a recommended…

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. Office Hours: Ask Me Anything About SQL Server in San DiegoWatch this video on YouTube Here’s what we covered: 00:00 Introductions 00:27 Alex: Hi…