Videos

I drove the Ferrari out through the Valley of Fire State Park and stopped out in the middle of nowhere to take the questions you’d upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Saket Mittal: Hi Brent, I am working with a developer on a query, this query has lots of join ,…

In ten minutes, let’s cover as many questions as possible from https://pollgab.com/room/brento: Here’s what we raced through: 00:00 Introductions 00:17 dbacat: We’ve been fighting an AG issue for a while. Sometimes during failover, one or a few databases go into initializing/recovery state on the new secondary. It’s random, never consistent. Only fix is to drop…

Most of the questions y’all post at https://pollgab.com/room/brento are technical ones, but there were a handful of interesting professional development and career ones in the queue, so I cherry-picked those for today’s episode: 00:00 Introductions 00:20 GI Joe DBA: Have you ever refused a consulting project \ opportunity and why? 03:35 Doug E: How do…

You posted questions at https://pollgab.com/room/brento, upvoted the ones you’d like to see me cover, and I did the needful: Here’s what we covered: 00:00 Introductions 01:19 chandwich: Hi Brent. I’ve been unsuccessful in my attempt to convince my employer I need formal SQL training. I help manage hundreds of customers’ SQL Servers and Applications, but…

On a road trip from San Diego to Vegas, I stopped in Palm Springs and answered your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:45 i_use_lowercase_for_select: Hi Brent, just wanted to give you my support on your May 24th blog. 01:19 SQL Crooner: Who would win a SQL trivia contest between Brent…

You posted and upvoted questions at https://pollgab.com/room/brento, and I sat down by the fire on a chilly evening in Vail, Colorado to answer ’em. I was driving cross-country, heading back from a road trip to see my mom. Here’s what we covered: 00:00 Introductions 00:46 Ms. Cosmos: What are the top traits for the perfect…

On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:20 YourbiggestFan: Do you have any plans to write an Azure first version of the first responder kit (sp_blitzfirst and sp_bitzcache)which can get the metrics from query store and thus overcome the issue…

I spent an entire video just talking about 3 questions y’all posted to https://pollgab.com/room/brento because these were pretty big-picture and important. I know it sounds goofy and sentimental, but I genuinely care about y’all’s careers, and I want you to work as little as practical in order to spend as much time with your loved…

Post your questions at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch. Here’s what we covered: 00:00…

It’s the first webcast I’ve done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones: 00:00 Introductions 02:15 Jim D: Should I use full backups or log shipping for migrations? 03:53 Sev A: What are the top misuses of SQL Server that are better accomplished without SQL Server?…

It’s the last San Diego balcony edition of Office Hours! You posted your questions at https://pollgab.com/room/brento and upvoted the ones you’d like to see. Here’s what we covered this week: 00:00 Introductions 00:50 Steve E: Hi Brent, How are you enjoying the Porsche 944? 01:55 Midwest DBA: Hey Brent, The wife says my DBA oncall…

You posted questions at https://pollgab.com/room/brento and I picked the fastest ones to answer: Here’s what we covered: 00:00 Introductions 00:16 Disgruntled App Developer: Hi Brent a friend was recently reprimanded for running a trace in production. The rationale was perf impact and other ‘potential issues’ that weren’t forthcoming. Any thoughts on why traces have an…

I’m back in the US at my home studio in San Diego, so I did a live Office Hours session. Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Introductions 00:41 WTF_SQLServer!?!: I have a some dbs that take nearly 6 hours each…

Ah, sunset – time to kick back on the balcony, watch the ocean, and discuss SQL Server. You post questions at https://pollgab.com/room/brento/, upvote the ones you’d like to see me answer, and I discuss ’em: 00:00 Introductions 00:30 iAmGroot: Hello Brent, my friend has a VLDB and he’s asking what is a good strategy to…

Ask me questions at https://pollgab.com/room/brento and upvote the ones you’d like to see covered. I can pretty well guarantee that your favorite question this time is going to be the last one I answered. Here’s what we discussed today: 00:00 Introductions 00:57 Sean W: New app with data model TBD; what is the thought process…

Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but we want war stories. I have heard your 174 indexes story twice now during recorded classes. Got any more? What are…

Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…

I had the pleasure of sitting down with David Giard virtually and discussing what developers need to know about databases. I always have fun talking with David – he’s a great follow on Twitter – and I think it shows in this conversation: Enjoy!

You posted and voted on questions at https://pollgab.com/room/brento and I answer ’em on the beach. It’s not your eyes: the camera’s hunting for focus a lot in this video. Here’s what we covered: 00:00 Introductions 01:01 RoJo: Please comment on the Cloud. Too much push at my company to the Cloud without backing to do…