Videos

While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:28 1440×1080: always on with 2 nodes 1db, readable secondary. I’ve optimized both nodes to a point where the primary can withstand both workloads.i want to downgrade licensing from enterprise to standard.…

I’m in Iceland this week, land of fire and ice, a place I keep coming back to over the years. It’s one of my favorite places on earth with stunning scenery, nice folks, and great restaurants. I paused at Godafoss to take your top-voted questions from Pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:56 MyTeaGotCold:…

When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on the south coast of Iceland, answering your top-voted questions from https://pollgab.com/room/brento. 00:00 Start 02:28 BoBo: Let us rate Brent’s shirts – I will start. “Morally flexible” and “Maybe today, Satan” are my top picks. Which one is…

Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:17 Pro: Are sessions sleeping during transactions harmful, and do they prevent the transaction log from truncating? If so, how can’t I prevent them server-side? 03:35 sqlknitter: We have high IO…

I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in Hawaii. I’m not really a Disney guy – we were there for a friend’s birthday celebration – but I tell ya what, that’s my new favorite resort in the world. The water park, food, beach, and nearby…

I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use the good microphone, so I re-recorded ’em from my home studio when I got back: Here’s what we covered: 01:04 NeedMoney: What’s the fastest/easiest way to make money as SQL Server Consultant (Production work, performance, health check,…

I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second gin & tonic. I, uh, might have lost my temper on the last one. Here’s what we covered: 00:00 Start 02:38 Frozt: are you familiar with SQL Server assemblies? and if they can cause assertion or IAM…

Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: What is table partitioning, and can it improve performance? Does its effectiveness depend on the underlying storage? In what scenarios is it most useful? 05:10 DBAMatt: If there was a new Mt. Rushmore with the heads of…

For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I’ve wanted to do for decades. Let’s bring you along and go through your top-voted questions from…

My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the town is chock full of gorgeous historic temples, and it was tough to pick a scene for today’s Office Hours. Let’s go through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 01:35 SQL_Linux: Brent!…

Kon’nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host and hostess clubs. I’m usually the kinda guy who does classy dinners at 5PM and then hits the sack by 9PM at the latest, so you might wonder how I got here. The answer is that Yves…

For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to you from the People’s Park in Zhengzhou, China, which is kinda like the Chicago of China. It’s in the middle of the US, bigger than people think (13 million people), and has beautiful parks. Here’s what we…

I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel.   Here’s what we covered: 00:00 Start 00:37 MyTeaGotCold: When was the last time you did something interesting with Extended Events? 01:25 Josef: Our app slows…

What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Have you ever had a client turn off RCSI? 01:31 SportsFan101: Hi! My company uses vmware for production(on-prem). Current wait time…

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…