Meme Monday: I got 99 problems but a disk ain’t one


May 2, 2011 by Mike Hillwig

Tom LaRock posted an interesting meme for today.  Here are my nine problems that aren’t disk.

  1. Vendors who make bad recommendations to my user community for “optimizing” SQL server, such as using autoshrink
  2. Other system administrators who insist on using SSMS from the database server
  3. An application that keeps changing the recovery model every time we upgrade
  4. A business application owner who doesn’t understand why I hate to make schema changes in the middle of the day
  5. Applications that create databases in locations other than the default paths I’ve specified in my server’s configuration
  6. A security system that will only run as SA
  7. An application vulnerable to SQL injection attacks that the business won’t spend money to replace/fix/secure
  8. An impatient application that sends an alert if it hasn’t been backed up in exactly 24 hours.
  9. A vendor who is taking their time in certifying and supporting SQL 2008 R2
  • They prlaobby won’t. And if they did, they prlaobby wouldn’t care all that much. Unless your personal server turns into more than that.But why not just use express edition and not worry about it? If you are going to hit the limitations express imposes, then you are prlaobby WAY beyond a personal server, and Microsoft might care. (But only if you are making money at this, because their lawyers need to get paid, and you can’t get blood from a stone).