Posts by Brent Ozar

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…