Videos

For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to you from the People’s Park in Zhengzhou, China, which is kinda like the Chicago of China. It’s in the middle of the US, bigger than people think (13 million people), and has beautiful parks. Office Hours: Answering…

I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel. Office Hours at the Petit Ermitage in LAWatch this video on YouTube   Here’s what we covered: 00:00 Start 00:37 MyTeaGotCold: When was the last time…

What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento. Office Hours: Car in the Dining Room EditionWatch this video on YouTube Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Have you ever had a client turn off RCSI?…

I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats – hang in there, I get it fixed in a few seconds. Office Hours: Ask Me Database QuestionsWatch this video on YouTube Here’s what we discussed: 00:00 Start 01:59 MyTeaGotCold: Your HA/DR worksheet mentions a $1,000,000 option for 0/0 RTO/RPO. Where can…

There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common: Office Hours: See if You Can Spot the ThemeWatch this video on YouTube   Here’s what we covered: 00:00 Start…

That face I’m making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out loud at this one. Anyhoo, let’s get to answering your top-voted questions from https://pollgab.com/room/brento: Office Hours: SQL Server Questions & AnswersWatch this video on YouTube Here’s what we covered: 00:00 Start 00:59 Mohit: Hello Brent, What options…

I took the Graffiti Gulf 356 out to the Valley of Fire State Park to exercise it, and took your top-voted questions from https://pollgab.com/room/brento. Office Hours: Valley of Fire State ParkWatch this video on YouTube Here’s what we covered: 00:00 Start 01:39 mailbox: Hey Brent! I’m really enjoying your prerecorded training classes. Quick question,I’m running…

I was making myself a drink to film Office Hours and I realized I should just film it in my home bar. I mixed myself a gin & tonic and took your top-voted questions from https://pollgab.com/room/brento: Office Hours: Let's Have a Drink TogetherWatch this video on YouTube Here’s what we discussed: 00:00 Start 00:50 MyTeaGotCold:…

It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I ended up in the same spot next to the Charter Street Cemetery that I filmed at last year! I went through your top-voted questions from https://pollgab.com/room/brento. Office Hours: The Warlock of DatabasesWatch this video on YouTube Here’s…

I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything About SQL Server and Azure SQL DBWatch this video on YouTube Here’s what we covered in this episode: 00:00 Start 03:15 Mattia Nocerino: I’ve always ignored database t-sql snapshots. What are good use cases, if any? 05:12…

I took a break from unpacking my SQL Saturday San Diego bags and re-packing for a Boston wedding long enough to take your top-voted questions from https://pollgab.com/room/brento. Office Hours: Back at Home (Briefly)Watch this video on YouTube Here’s what we covered: 01:55 Deadlockinator: Hi Brent, Why does sp_BlitzWho return NULL in the query_text for some…

On an unbelievably calm sea day off the shores of Canada, aboard the Norwegian Jewel, I enjoyed a nice cup of completely alcohol-free coffee (as far as you know) and took your top-voted questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything at SeaWatch this video on YouTube Here’s what we covered: 00:00 Start 01:20 NotCloseEnoughToRetirementToStopLearning:…

While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take your top-voted questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything in Haines, AlaskaWatch this video on YouTube Here’s what we covered: 00:00 Start 00:26 James L: When you were an employee, how did you decide whether to move on to another job?…

I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route to Icy Strait Point, Alaska, I took your top-voted questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything in Icy Strait Point, AlaskaWatch this video on YouTube Here’s what we covered: 00:00 Start 01:40 RollbackIsSingleThread: Hi Brent! If…

I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Office Hours: Open Q&A on Microsoft DatabasesWatch this video on YouTube Here’s what we covered: 00:00 Start 01:00 VegasDBA: Loved the Always-On Availability Group Episode! You mentioned how awful the dashboard is for monitoring. Can you recommend any scripts, custom…

I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Office Hours: Ask Me Anything About DatabasesWatch this video on YouTube Here’s what we covered: 00:00 Start 00:52 chandwich: If SSMS had a dark mode option that was equally as good as the existing light mode, would you use…

I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Office Hours: Database Q&AWatch this video on YouTube Here’s what we covered: 00:00 Start 00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a production DB. I want @param=222 to use the plan compiled…

Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera overheats, hahaha: Office Hours: Ask Me Anything About Azure SQL DB and SQL ServerWatch this video on YouTube We went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:43 cha2rg: We have an…