Videos

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:00 Start 00:32 Jeremy: We have an older web app we’re going to be rewriting…

Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: 00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a…

Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text form instead. <sigh> Thank goodness it was a speed round! Mike: When Brent Ozar’s certification exams for SQL Server will be available? Looking forward to having exams like “Fundamentals of QT”, “Mastering Server Tuning” etc, so you…

On the last day of my Israel trip, I went through the highly upvoted questions from https://pollgab.com/room/brento and answered ’em, standing in front of the beach. Here’s what we covered: 00:00 Start 00:37 AllThePartyPeople: On our server, MAXDOP=1 (not my choice); we had a poor performing SP call (called as dynamic SQL; again not my choice);…

The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered a few of your questions from https://pollgab.com/room/brento, rapid-fire style:   Here’s what we covered: 00:00 Intros 00:47 cyrpl: Hi Brent from PEI, Canada. A support person told me today that when creating a table, an ID column…

Before speaking at the Data TLV Summit, I sat by the Mediterranean Sea and discussed the top-voted questions you posted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Manikandan GS: As postgres being one among the RDBMS lane, do you think postgres is having more features and flexibility compared to MS-SQL Server? 02:46 PaginationWoo!:…

Got questions about the Microsoft data platform? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today’s episode finds me in my home office in Vegas: 00:00 Intros 02:10 GeorgeDAX: Hello Brent, I’m a dealing with a huge sales table which contains around 500 columns with 50m rows. Business asks…

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered: 00:00 Introductions 00:59 Haydar: What tools do you like to use when troubleshooting azure sql db query…

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered today: 00:00 Introductions 00:25 Kebros: Hi Brent.My manager wants me to summarize sql health into a number…

Post your Microsoft data platform questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. I sat down by the pool in Cabo with a cup of coffee to go through ’em: Here’s what we covered in this episode: 00:00 Introductions 00:43 MergeItLikeItsHot: Hi Brent, do you have any good resources to…

I hopped down to Cabo San Lucas and sat at the End of the World to answer the questions you posted & upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Intros 00:44 Kirk Saunders: Hey Brent! When did you determine your knowledge/skillset/etc.. was sufficient to teach your various classes? I think I’m doing well at…

Not all of the questions you post at https://pollgab.com/room/brento require long answers. Here’s a quick speed round: Here’s what we discussed: 00:00 Introductions 00:24 EngineHorror: Hey Brent! What’s your opinion on page- and row-level compression in general? Is it true it increases locking besides burning extra CPU? 01:08 Pony: Is Microsoft Assessment and Planning tool…

This time on Office Hours, I let a few questions piled up at https://pollgab.com/room/brento that required in-depth answers to really do ’em justice. In particular, there was a statistics question that needed demos. Here’s what we covered: 00:00 Introductions 00:35 Grogu: Did DBA Brent ever have to support a version of SQL Server that Microsoft…

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today, I’m dodging work, so I went through your questions while I waited for the coffee shop to open: Here’s what we covered: 00:00 Introductions 03:28 Ivan: What are the top signs that a table has a poor clustered index?…

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…