Data Base Design

This looks like a good general article on database design: http://www.databasejournal.com/features/mssql/article.php/

There is also an article in using stored procedures with error reporting: http://rwgarrison.com/rg/Writing/ErrorCheckingPart1.htm

This used in debugging.

This can be used in testing: http://www.tsqltest.org/

It is a simple, lightweight testing framework for Microsoft SQL Server. It is a free application.

This is a set of SQL procedure standards: http://rwgarrison.com/rg/DevStds/

All of the above articles where done by Rob Garrison.