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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access