The Ten Database Commandments

  1. Thou shalt always design databases from a logical data model.
  2. Thou shalt always document thy database design.
  3. There are many important aspects of database administration, but of them all, data integrity shalt always remain the most important.
  4. Thou shalt encrypt personal and sensitive information, both at rest and in transit.
  5. Thou shalt implement appropriate security within thy database and between thy DBMS and thy operating systems.
  6. Thou shalt always maintain the recoverability of thy databases with sufficient backups to meet the availability requirements of the business supported by the data.
  7. Thou shalt implement and document a consistent workflow process for implementing database change that assures data integrity while minimizing downtime.
  8. Thou shalt always consider transaction performance in thy database design.
  9. Thou shalt work with application developers to ensure efficient code is written to access thy databases.
  10. Thou shalt not download thy database to thy laptop.
Advertisements

About craig@craigsmullins.com

I'm a strategist, researcher, and consultant with nearly three decades of experience in all facets of database systems development.
This entry was posted in DBA. Bookmark the permalink.

2 Responses to The Ten Database Commandments

  1. lista de says:

    thanks for the interesting article.

  2. business lists says:

    Usually I don’t learn post on blogs, but I wish to say that this write-up pressured me to try and do so! Your writing taste has amazed me. Thanks, quite great post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s