Wednesday, April 16, 2008

Ten Common Database Design Mistakes

1. Poor design/planning
2. Ignoring normalization
3. Poor naming standards
4. Lack of documentation
5. One table to hold all domain values
6. Using identity/guid columns as your only key
7. Not using SQL facilities to protect data integrity
8. Not using stored procedures to access data
9. Trying to build generic objects
10. Lack of testing

Source

Labels:

Monday, March 31, 2008

ASP.net - Connect to and use an Access2007 .accdb Database