Videos

Office Hours - ask me anything.

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

Videos
4 Comments
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…
Read More

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

Videos
1 Comment
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…
Read More
Office Hours - ask me anything.

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

Videos
0
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…
Read More

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

Videos
3 Comments
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…
Read More
Office Hours - ask me anything.

[Video] Office Hours: SQL Server at Sunset

Videos
0
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…
Read More

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Videos
4 Comments
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…
Read More

[Video] Office Hours: First Post From Cabo

Videos
0
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…
Read More
Office Hours Podcast

[Video] Office Hours: SQL Server 2008 R2 Edition, I Guess

Videos
0
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…
Read More
Office Hours - ask me anything.

[Video] Office Hours Speed Round: 17 Answers in 11 Minutes

Videos
1 Comment
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…
Read More

[Video] Office Hours on the Balcony Part 2

Videos
0
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…
Read More

[Video] Office Hours on the Balcony Part 1

Videos
1 Comment
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…
Read More

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

Videos
0
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…
Read More

[Video] Office Hours Speed Round: Quick Answers

Videos
1 Comment
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…
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: 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…
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

[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. 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…
Read More