Archive | Best Practices RSS feed for this section

DBA Lessons From a Snowy Winter

I live in New England. I expect snow in the winter. This winter, though, has been a bit of an anomaly from recent winters for us. We started out with very little snow, abnormally little snow. But then it came (and it is still coming) all at once. Over about 4ish weeks we had a […]

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 […]