Backup design, restore testing, integrity checks, and corruption response.
292 associated posts117 primary posts
I was in Rome to attend a teaching conference, and my AirBnB had the most beautiful view overlooking Rome and Vatican City. While having my morning coffee, I went through your top-voted questions from https://pollgab.com/room/brento - and I didn't go through many questions because some of them required really long answers, and I had a great time with those.
You were minding your own business, and all of a sudden it happened.
You glanced at file sizes one day, and your eyes got big. The numbers got a little large while you weren't looking. This is a great time to stop and think about a few changes to the way you're managing this database.
I flew into Wales a couple days early to get used to the time zones, and showed up at the conference center where SQLBits would be located. Let's go through your top-voted questions from https://pollgab.com/room/brento on a very chilly morning:
https://www.youtube.com/watch?v=6XjBwH7NzfA
Let's hang out in my home office in Vegas and go through your top-voted questions from https://pollgab.com/room/brento. The audio's a little echo-y in this one because I just moved my office down to a small first floor guest bedroom with hardwood floors instead of carpet, and I haven't treated the room for noise yet.
Sandra Delany (LinkedIn) wrote a well-thought-out blog post called, "Should a SQL Server DBA Know Windows Clustering?" She's got about 20 years of DBA experience, and she works for Straight Path (a firm I respect) as a consultant. You can probably guess based on her background that yes, she believes you should know how to set up, configure, and troubleshoot Windows clustering. It's a good post, and you should read it.
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.
https://www.youtube.com/watch?v=XcNJVJ1-XaE
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.
https://www.youtube.com/watch?v=v7-Bq9qmDX8
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.
Last week, I asked y'all how frequently you ran your full backups, corruption checks, index maintenance, and stats updates. The results after over 1,000 responses:
A few thoughts:
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.
https://www.youtube.com/watch?v=-yd59N2bWzQ
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:
https://www.youtube.com/watch?v=ja90e234rIo
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=_NLtbul3Nyc
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.
https://youtu.be/49Ycmorwk_g
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.
https://youtu.be/3ez2m-Hev9E
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.
https://www.youtube.com/watch?v=nGoE17cSdl8
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=gkeEKyzc01M
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:
https://youtu.be/6zpEXYeDH1Q
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 planned this trip out, hahaha, so here we are. As long as we're here, let's go through your top-voted questions from https://pollgab.com/room/brento.
I'm back in the home office to take your database questions from https://pollgab.com/room/brento.
https://youtu.be/H70Iy6bX970?si=6UZJbG89FC6bVni4&t=15
I'm on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route to Icy Strait Point, Alaska, I took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=VzlKubfSaDs
