Top 10 Mistakes When Building and Maintaining a Database
Top 10 Mistakes When Building and Maintaining a Database is a good overview of what not to do when creating a database.
The only caveats I offer about this article:
- The article is SQL Server-centric; and
- Mistake #4, "Use of Adhoc Queries", seems to be true only when you have a large, heterogenous development staff (like 10+ developers). Smaller development groups don't seem to suffer from allowing ad hoc queries by developers. (Perhaps it is mainly a communications problem, rather than just an allowing ad hoc queries problem?)