- Denish Patel
- 13th August 2014
- Database
After having decade of experience managing small to large scale and/or varieties of database systems, here is my first try to come up with the top ten commandments of database management !
- Thou shalt always learn database systems strengths and weaknesses
- Thou shalt choose appropriate database to store and process data to empower business
- Thou shalt always build systems to be resilient/cope with failures
- Thou shalt implement automated restore procedures to test backups
- Thou shalt always trend and monitor database performance and maintenance metrics
- Thou shalt document and follow database change management procedure
- Thou shalt plan to upgrade database systems in timely manner
- Thou shalt always build tools to automate processes
- Thou shalt implement security policy and processes to secure data
- Thou shalt educate developers to write efficient code against databases
If your commandments list differs from mine, I’m interested to know your list. Please don’t hesitate to post in comment. Thanks!
9 replies on “10 commandments of Database Management”
Comments are closed.
Categories
Recent Blog
- Do you really need a DBA?
- Running VACUUM FULL in Non-blocking Mode
- Connection Scaling
- PSQL Helper: Managing Connections and Simplifying Queries
- Vacuum Those MVs!
- Working With Repmgr: Using Other 3rd Party Tools for Setting up a Standby
- Working with Amazon Aurora PostgreSQL: dag, standby rebooted again!
- Working with Amazon Aurora PostgreSQL: what happened to the stats?
- How to set application_name for psql command line utility?
- Is there a limit on number of partitions handled by Postgres?
Thou shalt sanitize thy database !
0. Start with the where clause. Not so much database management as operator-induced disaster avoidance.
Thow shalt never delete data
Amen to that. I cannot tell you how many times I’ve had to trace some user tiptoeing through the tulips accidentally altering or deleting something critical. Having soft-deleted data gives you a way to restore stuff quickly, or at least view data as it was before the action to confirm the change was necessary.
Wait… did I say “tiptoe”? I meant “bulldozing”. 🙂
Thou shalt sanitize thy developers !
Thou shalt not use the word database to refer to database management system
Thou shalt maintain and monitor thy schema in a Version Control System.
Thou shalt see the Cloud up high above and recite, “In God we trust, all else must provide data”.
Thou shall keep your Encryption Keys and Certifcates backed up in a very safe place…