100+ SQL Server DBA Myths Debunked, Discussed, Explained, Resolved, etc.

In recovery… Paul S. Randal on SQL Server - T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!!

“Back in April I spent an entire month doing a DBA-Myth-A-Day series once a day which was all about misconceptions. So, rather than repeating some of what I said then, or spilling the beans on some more myths I'll be discussing at PASS and SQL Connections in November, this post will be an uber-list of all the misconceptions I debunked during April - and, boy, there are a lot of them! I keep hearing these myths over and over, from all kinds of people, including SQL MVPs, vendors, and consultants.

These posts explain in detail why the misconception is a misconception and in many cases use a script to prove it as well.

• A SQL Server DBA myth a day: (30/30) backup myths
  • This post debunks my top 30(!) myths around backups.
• A SQL Server DBA myth a day: (29/30) fixing heap fragmentation
• This post explains why dropping and recreating a clustered index is not a good solution for removing heap fragmentation.…
• A SQL Server DBA myth a day: (1/30) in-flight transactions continue after a failover
  • Common failure when designing and HA strategy.

And there you have it - over 100 myths and misconceptions debunked, explained and, in many cases, proven!

…

…”

Since I play the role of a DBA’s Worse Nightmare during the day (aka a Dev who likes to pretend he’s a pseudo-DBA… ;) I found Paul’s “A SQL Server DBA myth a day” series a huge value.

I’ve been developing against SQL Server since 4.21a (i.e. the first version on Win NT 3.51) and still fall into the Myth pit. I’ll bet money that anyone doing SQL Server stuff will have a few “ah-ha” or “oh…” moments when reading them. If you’re a SQL Server DBA, or just play one on TV, this is must read series of posts…