Videos

I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I ended up walking right past it while visiting Barcelona! It’s one of the most important beginnings of modern architecture, and I loved it. I brought you along with me and talked through your top-voted questions from https://pollgab.com/room/brento.…

I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to kill, so let’s go through your top-voted questions from https://pollgab.com/room/brento. Office Hours in the Detroit AirportWatch this video on YouTube Here’s what we covered: 00:00 Start 00:39 SQLLearner: Hi Brent! I’m curious about the two versions of…

While recovering from a nasty cold, I took your top-voted questions from https://pollgab.com/room/brento. Office Hours: Recovering from a ColdWatch this video on YouTube Here’s what we covered: 00:00 Start 03:13 Haruki Tanaka: Hi Brent, The stored procedure has 12 parameters, and users pass various combinations of values to it. I rewrote it using dynamic T-SQL,…

Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of myself for that one. Office Hours at the Hoover DamWatch this video on YouTube Here’s what we covered: 00:00 Start 02:20 The Princess and the Frag: On SQL Server 2019 or later, are reorganising a columnstore index…

Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round: Office Hours: Speed Round!Watch this video on YouTube Here’s what we covered: 00:00 Start 00:34 Alain Térieur: Hi Brent. I started the restore of a (big) DB. And it took more than 2h before the resore actually started. What…

I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, and… it’s still pretty weird. Let’s go through your top-voted questions from https://pollgab.com/room/brento and have a laugh at my hot dog fingers. Office Hours: Hot Dog Fingers EditionWatch this video on YouTube I didn’t mention in the…

On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer your top-voted questions from https://pollgab.com/room/brento: Office Hours: Hello Kitty Porsche EditionWatch this video on YouTube Here’s what we covered: 00:00 Start 00:56 TheWorstDBA: I have a large table with 50 billion rows. It has a partition implemented…

On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. Office Hours in the Home BarWatch this video on YouTube Here’s what we covered: 00:00 Start 00:57 jrl: Do you have any advice about communicating effectively in a fully remote workplace where all discussion is centered around…

Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I joined in this year, and before the tournament, sat on the shores of Lake Napissing to answer your top-voted questions from https://pollgab.com/room/brento. Office Hours in North Bay, CanadaWatch this video on YouTube Here’s what we covered: 00:00…

One of the things I love about TikTok is that it exposes me to wildly new video ideas like this: @tiipititap ? original sound – tiipititap There’s a whole genre of videos in that style – people using tapping plastic pointer fingers on a grainy screen with no voiceover. One sub-genre (like the video above)…

I’m doing a lot of travel this month, but I took a break in my Vegas backyard to go through the top-voted questions from https://pollgab.com/room/brento. Office Hours in My Vegas BackyardWatch this video on YouTube Here’s what we covered: 00:00 Start 00:29 Nick H: I’m a new starter at an organisation who have lots of…

I’m back home after a 2-week Iceland vacation. Let’s catch up with your top-voted questions from https://pollgab.com/room/brento. Office Hours: Back Home After IcelandWatch this video on YouTube Here’s what we covered: 00:00 Start 02:04 Suresh: Hi Brent . Question about 128 GB memory limit for SQL server standard edition.If I set ‘Max SQL Server Memory’…

While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Office Hours: Waiting for My Icelandic Hot Tub to FillWatch this video on YouTube 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…

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. Office Hours: Philosophical Tech Questions at the Waterfall…

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. Office Hours: Unusual Beach Chairs EditionWatch this video on YouTube 00:00 Start 02:28 BoBo: Let us rate Brent’s shirts – I will start. “Morally flexible” and…

Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. Office Hours with my Honda BeatWatch this video on YouTube 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 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: Office Hours: Home Office EditionWatch this video on YouTube Here’s what we covered: 01:04 NeedMoney: What’s the fastest/easiest way to make money…

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. Office Hours in my Vegas BackyardWatch this video on YouTube Here’s what we covered: 00:00 Start 02:38 Frozt: are you familiar with SQL…

Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Office Hours: Long Answers EditionWatch this video on YouTube 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…