Best Practices

How to Assess Your SQL Server Environment

Give me six hours to chop down a tree and I will spend the first four sharpening the axe. Abraham Lincon Welcome back to the Two Weeks to A Healthy SQL Server series of posts! This is the official “Day One” post. This first step may not be the most glamorous or the biggest payoff, … Read more

VMware and SQL Server Best Practices.

I wish you knew a few things about VMware and SQL Server best practices. If you’ve ever asked yourself “Why does my storage seem slower on my SQL Server VMs?!”, this post may help. We love VMware in our SQL Server consulting practice. But there are some things you should know and do first. These … Read more

Hey DBAs, Don’t Be Like the Secret Service!

Last week, I ripped a story from the headlines to draw lessons for Technologists from – it was about the Secret Service lapses that allowed a fence jumper to get into the threshold of the White House residence. That was bad. This week, though, we’ve learned of some additions to the story that makes it … Read more

SQLU DBA Week – Set It And….

Welcome to the third day of DBA week at SQL University. On day one, I kicked off the “back to basics” journey I’ve chosen for fellow students with my post reminding you that you’re only as good as your ability to restore. Microsoft Certified Master Robert Davis brought us a good reminder on Day 2 … Read more

SQL 2008 R2 LoadFest – Session Notes

I spoke today at the SQL Server 2008 R2 Load Fest put on by Andy Novick of Novick Software. Great turnout, and it is always fun to see so many folks working together on the task of figuring out the nuances of SQL Server installations together. Also good to see that you were able to … Read more

Hey Software Vendors – Get a Clue!

Psst. Hey Vendor – DBAs are secretly plotting against you! We hate what your products do to our environments. Sometimes we even work to get you replaced by someone else who makes a product in the same space but is “DBA-Approved”… (Quick Edit March of 2021). In the time since writing this post, I’ve grown … Read more