Posts by Brent Ozar

Today’s batch of questions from https://pollgab.com/room/brento requires some really long answers, and some are right to the point. Office Hours: Really Long Answers and Really Short OnesWatch this video on YouTube 00:00 Start 02:13 Eh? Aye…: As DBAs, how can we best prepare for the AI world in terms of data? Should we start with…

We headed up to the mountains to get away from the Vegas heat. Before the sun rose, I took your top-voted questions from https://pollgab.com/room/brento. Office Hours in Telluride, ColoradoWatch this video on YouTube   Here’s what we covered: 00:00 Start 00:36 Ozan: Hi Brent, how should Volume Snapshot Backups (VSS) be configured correctly that it…

I took a break from packing my bags long enough to answer your top-voted questions from https://pollgab.com/room/brento. Office Hours: Before Heading Out on VacationWatch this video on YouTube Here’s what we covered: 00:00 Start 02:42 T-man: Hi BO. A friend has multiple Distributed AGs (on separate business division servers) but needs to share ODS data…

I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube   Here’s what we covered: 00:00 Start 00:39 tanchenglai: Hi Brent! We bought your Level 2 Bundle last year. Recently, we went into frequent thread pool issues;…

Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Office Hours: Extended EditionWatch this video on YouTube Here’s what we covered in this episode: 00:00 Start 02:17 Tanchenglai: Hi Brent, recently we always ran into thread pool issue. I checked Performance Dashboard and found that CPU spiked over…

I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Office Hours: While Brent's Pool RefillsWatch this video on YouTube Here’s what we covered in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a node in AWS for DR. We are thinking of…

There are only a couple weeks left in this summer’s marathon of Office Hours sessions, which means there’s limited time left to ask your toughest database problems (not trivia questions) at https://pollgab.com/room/brento. Office Hours: Ask Me Anything About Microsoft DatabasesWatch this video on YouTube Here’s what we covered in this episode: 00:00 Start 03:22 tanchenglai:…

I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic. Office Hours: Ask Me Your Microsoft Database QuestionsWatch this video on YouTube Here’s what we covered: 00:00 Start 04:50 JudgeDredd: Hi Brent, have you ever been asked for opinion/expertise (as a database specialist) in a court trial? If…

Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you’d like to hear me discuss. Office Hours: Ask Me Anything in VegasWatch this video on YouTube Here’s what we discussed in this episode: 00:00 Start 02:47 therealprodDBA: In the last webcast, I heard you cite that majority of your…

Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like I do on most Wednesdays & Thursdays, and really enjoyed these: Office Hours: SO MANY Good SQL Server QuestionsWatch this video on YouTube Here’s what we…

Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Office Hours: Stack Overflow is Down!Watch this video on YouTube Here’s what we covered: 00:00 Start 04:33 Amir: Does Az-900 worth the effort and money? What about other microsoft certifications? 06:16 Mr. M: Hi Brent. Which feature in…

Almost all of today’s questions from https://pollgab.com/room/brento were great! Well, except two. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube Here’s what we covered: 00:00 Start 02:13 Andrei: What’s the appropriate response/punishment for developers who insist on storing json and xml in nvarchar(max) fields? 03:43 JustGoogleIt: What are your thoughts on…