10 commandments of Database Management

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 !

  1. Thou shalt always learn database systems strengths and weaknesses
  2. Thou shalt choose appropriate database to store and process data to empower business
  3. Thou shalt always build systems to be resilient/cope with failures
  4. Thou shalt implement automated restore procedures to test backups
  5. Thou shalt always trend and monitor database performance and maintenance metrics
  6. Thou shalt  document and follow database change management procedure
  7. Thou shalt plan to upgrade database systems in timely manner
  8. Thou shalt always build tools to automate processes
  9. Thou shalt implement security policy and processes to secure data
  10. 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 thoughts on “10 commandments of Database Management”

    1. 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”. 🙂

Comments are closed.