Videos

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. 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 I learn more about how this? 04:43 Trushit: It was…

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:   Here’s what we covered: 00:00 Start 01:51 Tivan: Hi Brent, I’m facing a deadlock in MS SQL Server with…

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: Here’s what we covered: 00:00 Start 00:59 Mohit: Hello Brent, What options does a DBA have in terms of performance tuning when managing…

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. 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 sp_BltizCache @SortOrder = ‘reads’ on our DW server and receiving a…

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: Here’s what we discussed: 00:00 Start 00:50 MyTeaGotCold: Can you name anyone who radically disagrees with you? After nearly…

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. Here’s what we covered: 00:00 Start 01:28 Dumped_on_DBA: How would you…

I’m back in the home office to take your database questions from https://pollgab.com/room/brento. 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 All.. Night.. Log..: Any recommendations for what to do when we hit high Tlog VLF count…

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. Here’s what we covered: 01:55 Deadlockinator: Hi Brent, Why does sp_BlitzWho return NULL in the query_text for some SPID, even when I’m running it as sysadmin? It also…

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. Here’s what we covered: 00:00 Start 01:20 NotCloseEnoughToRetirementToStopLearning: Inherited a server with dozen trace flags on but no documentation…

While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take your top-voted questions from https://pollgab.com/room/brento. 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 think a similar dilemma exists when you’re trying to decide whether…

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. Here’s what we covered: 00:00 Start 01:40 RollbackIsSingleThread: Hi Brent! If a high-quality blog post involves original ideas, T-SQL, a great demo, and images to…

I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. 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 alerts, or dashboards to keep a better eye on things? 03:26…

I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. 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 it? Any idea why it doesn’t exist yet? RE: The on-call…

I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: 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 with @param=111 like it did in production. In…

Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera overheats, hahaha: 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 OLTP table size of 4TB and rows of 6 billion. Scheduled an old data deletion job…

Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can’t see the questions onscreen. Nonetheless, there are good answers in here, so let’s do it:   Here’s what we covered: 00:00 Start 00:03 LivingTheDream:…

I was supposed to be on a flight to Mexico, but had to cancel at the last minute. While waiting for my favorite bagel shop to open, I went through your professional development questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 03:25 Asking for a friend: As a prod dba, should I know what…

I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones: Here’s what we covered: 00:00 Start 01:10 Trushit: You mention in your career internals guide that you focused on high value things for which business are willing to pay. How did you control the temptation of trying to learn everything & focus on…