Videos

The Dotonbori area of Osaka is like a video game version of Japan: wild, over-the-top neon signs, awesome street food, cool street markets, Kabuki theater on a revolving stage, and more. It’s very touristy, but as touristy places go, it’s fantastic. Last year when I was here, I filmed Office Hours at the river, but…

I really wanted to film Office Hours on the Great Wall of China, but the instant I got out there, I realized it was a lost cause. That place was SO overwhelming – tons of people, frigid winds, heights, totally overwhelming in every way. So, instead you get a nice peaceful park in downtown Zhengzhou,…

I drove the Graffiti Gulf out to The Last Spike (video) outside of Las Vegas and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Jan de Graaf: Our database landscape seems CPU-bound. We sometimes hit 100% CPU with organic load. We’re considering new hardware. Do you think memory speed plays…

I threw in the towel on my workday at 3PM when everything started going wrong in the Ozar home office, so I switched to answering your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 03:59 MyTeaGotCold: How often do you see indexed views these days? 04:14 I 3Fedora: Hi Brent, Not strictly database…

It’s the perfect time of year in Las Vegas when we can chill outside by the fire, enjoy a glass of wine, and go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:54 iliyan Rashev: Hello Brent, I am on SQL Server 2019 RTM Please recommend a patching path: 1. Apply…

My cruise ship took a detour to Honduras to avoid the hurricane. Let’s hang out on the beach and go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:58 Dopinder: What is your opinion of the Github copilot support in SSMS 22? Is this more beneficial for the DBA or Data…

This Office Hours episode comes to you from Virgin Voyages’ newest cruise ship, the Brilliant Lady, sailing through the Western Caribbean. We were originally scheduled to do the Eastern Caribbean, but Tropical Storm Melissa had other ideas, so they reworked our itinerary at the last minute. Let’s take your top-voted questions from https://pollgab.com/room/brento: Here’s what…

Let’s hang out in the backyard – as recently seen on Zillow Gone Wild – and take your top-voted questions from https://PollGab.com/room/brento. Here’s what we covered: 01:09 AussieDBA: I was saddened to hear of the passing of Andrew Clarke, who surely had the best pseudonym in the SQL industry, Phil Factor. His articles were some…

I’m back at home in Vegas, taking your top-voted questions from https://pollgab.com/room/brento on a hillside enjoying the fall desert weather. Here’s what we covered: 00:00 Start 03:10 Bruce: Howdy! When, if ever, would you recommend implementing a SQL Server Central Management Server? 04:09 Impostor Syndrome: Are multi-TB databases really all that rare? I have several…

In between clients, I hopped onto my Twitch channel to take your top-voted questions from https://pollgab.com/room/brento. If you’d like to get notified whenever I do one of those live streams, you can follow my channel for free and you’ll get email notifications automatically. I do ’em whenever I have time, usually about once a week…

In retrospect, I should have put on sunscreen – even for just a 20-minute Office Hours session on the beach! Dang, that sun is powerful. Let’s go through your top-voted questions from https://pollgab.com/room/brento. This is a 360-degree video, so if you watch it on YouTube, you’ll be able to pan the camera around and take…

I’m back in Vegas, at least for the moment, so let’s hang out in my home office and talk through your top-voted questions from https://pollgab.com/room/brento. There’s a lot of good questions this week! Here’s what we covered: 00:00 Start 02:26 Eric M: I’ve recently become very disenchanted with the commercial SQL Server monitoring tool I…

On the last day of my Caribbean cruise, as we pull into port in Miami, let’s go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Sean: How would you approach a task to remove 90% of the data to support lightweight test db servers. I’m thinking of a script with…

The first few questions from this week’s crop at https://pollgab.com/room/brento are very much about what-problem-are-you-trying-to-solve, but they get more complex from there. Here’s what we covered: 00:00 Start 02:49 My Erik is Strong: Do you suggest any steps after an upgrade to SQL Server 2022 in particular? I mean 2022 features to try, enjoy, or…

Wanna hear about my worst job interviews? I drove up to 8,000 feet where it’s 30 degrees colder than Las Vegas to bring you these answers to your top-voted questions from https://pollgab.com/room/brento. The audio’s a little odd on here because it was really windy, and I had to use noise reduction in post-production. Here’s what…

Let’s hang out, listen to the peaceful waterfall, and go through your top-voted questions from https://pollgab.com/room/brento. This is kinda the calm before the storm: in another week, I’ll be on the road again for a while, hopefully bringing you some fresh Office Hours locations from the Caribbean and Alaska! Here’s what we covered: 00:00 Start…

I’m finally back in the home office after running around Europe for a month. Let’s talk through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:52 World Peace: Hey Brent, I am working in AZURE currently and the AZURE architect is placing all the mdf and ldf files on one drive and…

When I’m on the road, I try to take you along with me to glamorous or scenic locations to give you a change of pace. However, last week in London was a bit of a whirlwind between SQLBits and restaurants, so at the last minute, I recorded Office Hours in my hotel room! I went…