Friday, February 26, 2010

Database Design Mistakes

Hi All

This is my first article. hooray for sql server and my friends specially
Gogula (MVP - SQL Server), Dinesh P (MVP - SQL Server) and a lot more.. and more specially Roshan M Karunaratne my Head of IT. Thank you all for yours' valuable information...

Let's back to our topic.

Since this is my first article, I would prefer to present this as simple as possible.
So, as developers (.net, database or another technology developers) we make mistakes and make sure that the same mistake will not repeat in the future.

Hopefully, after reading this article, you will realize that what practices and terms should be considered when designing a database.

So, here are the things...
  • Poor designing / Planing.
  • Normalization issues.
  • Proper naming standards.
  • Documentation issues.
  • One table to hold all domain values.
  • Using identity/guid columns as your only key.
  • Not using SQL facilities to protect data integrity.
  • Not using stored procedures to access data.
  • Lack of testing.
I will be discussing these issues one by one in my next post and it will be available for you by 28th of Feb 2010.

Thanks