Archive | Best Practices RSS feed for this section

kCura’s k-rad Idea & A Vendor Doing SQL Better

k-rad.. K  From kilobyte.. A thousand.. A thousand times Rad.. Back when a 40MB hard drive was perhaps average or maybe around the time of those big 1.6GB hard drives, it meant “really cool”.. Maybe today it would ex-rad or p-rad. Anyway. There’s a reason for this trip down BBS or mIRC memory lane.. We’ll get […]

Hey DBA Managers, Don’t Be Like the Secret Service!

Continuing from yesterday’s advice to DBAs…  Three Four (hey it’s for managers, brownie points…) lessons for management from the Secret Service “issues”.   Trust But Verify At the White House “upper management” at Secret Service didn’t realize how bad things were with recent lapses. At least I hope they didn’t and I’m going to assume they […]

More Soft Skills From The Ambulance

A couple days ago I posted some of the lessons I learned in the back of an ambulance that have translated into my career as a SQL Server Consultant or a DBA. I promised I had a few more.  Here they are. “I Don’t Know What You’ve Been Through” Empathy. My friend Tom LaRock wrote an […]

5 Database Lessons From The Bathroom…

I’m writing this post from my living room, don’t worry. A recent last minute trip to replenish the household toilet paper supply had me thinking of this illustration. So…. I’m a big fan of finding lessons for the day job from everyday life – call them illustrations, if you want. I’ve found inspiration preparing for […]

Check Your SQL Server Configuration

I blog a lot about best practices, defaults and paying attention to your installations. It’s a huge pet-peeve of mine to see improperly configured instances. One of the things I always do when doing a health check is review an instances configuration options. On quite a few client environments, just a couple quick knob turns […]

How Do You Prevent a SAN Failure?

… Well, prevent a SAN failure from ruining your week anyway. Because you can never fully prevent a failure 100% – even in a SAN, even when your SAN vendor says it’ll never happen (hint: anytime a vendor tells you never – be afraid.. Be very afraid). So that’s what this whole post series is […]

Yes Virginia, SANs Can Fail

“Well that’s on the SAN, so it’s good,” better never be a part of your recovery plan. If it is? You just lost. As I type this I’m on the way home from a city from an old client that just lost their SAN – their SAN that every VM was on, their SAN that their company […]