Archive | Best Practices RSS feed for this section
2917811282_70e20cd396_z

SQL Server Licensing Or Tax Forms?

by Mike Walsh on 27. Jul, 2010 in Best Practices, DBA, InstallTips, Pet Peeve, Syndicate

Which would you rather do, wade through the nuances of SQL Server licensing or a typical tax form?  Some days, I think the latter would be a welcome respite. Let’s just put it this way, I bet Brent Ozar (BrentO on twitter) is happy that licensing wasn’t the biggest part of the MCM grade. (I [...]

  • Share/Bookmark
Read full story • Comments { 10 }

Linked Server Query Running Slow?

by Mike Walsh on 08. Jul, 2010 in Best Practices, Performance, Syndicate, T-SQL

Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –>
It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up the [...]

  • Share/Bookmark
Read full story • Comments { 4 }

Hey Software Vendors – Get a Clue!

by Mike Walsh on 02. Jul, 2010 in Best Practices, InstallTips, Pet Peeve, Syndicate, Troubleshooting

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”….

What’s that? You want the DBA stamp of approval?
I write this blog to help folks [...]

  • Share/Bookmark
Read full story • Comments { 16 }
truck-side

Why Hire A DBA?

by Mike Walsh on 24. May, 2010 in Best Practices, DBA, Syndicate, Troubleshooting

Why on earth would anyone hire a Database Administrator? Your Windows Admin can install SQL Server with just a few clicks – It only takes a few more clicks to put a database there and grant permissions. Most of your vendors have simple setup scripts including database deploys… Why spend all that money on a [...]

  • Share/Bookmark
Read full story • Comments { 9 }
Older Entries »