Appendix A. Top 25 DBA worst practices
While there may be some disagreement on best practices, there is usually no argument on worst practices, some of which are listed below (in no particular order):
Not considering service-level agreements (SLAs) when designing a database environment and/or not considering the need for scheduled downtime for various maintenance activities, such as the installation of service packs.
Defining "disaster" too narrowly and not simulating/practicing a disaster recovery (DR) plan. Having a DR plan is fine, but how do you know it will work (and several people can follow it) when required?
Designing a storage system from a capacity perspective alone.
Assuming a storage area network (SAN) will meet/exceed performance requirements. ...
Get SQL Server 2008 Administration in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
