I'll add one more to the list.
Disaster recovery
- Know how to fix corruption
- Know what to do when someone drops a table (though if you've done the security right, that shouldn't be possible)
- Know how to restore to any point given your backup strategy
- Practice various scenarios so that if something does happen, you know exactly what to do.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability