Videos

[Video] Office Hours: Ask Me Database Questions

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

Office Hours: Guess the Theme Edition

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

[Video] Office Hours: SQL Server Questions and Answers

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

Office Hours in the Valley of Fire

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

[Video] Office Hours: Let’s Have a Drink

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

[Video] Office Hours: Salem Witchcraft Edition

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

[Video] Office Hours: Open Q&A About Databases

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

[Video] Office Hours: Back at Home (Briefly)

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

[Video] Consulting Lines

Consulting Lines, Videos
2 Comments
In my consulting work, I often find myself saying the same things to clients – but they’re not the kinds of things I said when I was a database administrator. I call these “Consulting Lines”, and I talked through ’em:   Here’s my full series of Consulting Lines blog posts: “Yes, that used to be…
Read More

[Video] Office Hours on a Calm Sea Day Off Canada

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

[Video] Office Hours in Haines, Alaska: No Bears Here

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

[Video] Office Hours: Icy Strait Point, Alaska

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

[Video] Office Hours: Open Q&A on Microsoft Databases

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

[Video] Office Hours: Open Q&A About Databases

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

[Video] Office Hours: Database Q&A

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

[Video] Office Hours Q&A: Abrupt Exit Edition

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

[Video] Office Hours: Abrupt Intro Edition

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

[Video] Office Hours: Professional Development Q&A

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

[Video] Office Hours: Ask Me Anything About #SQLServer

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