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.

OLE DB

OLE DB - Object Linking and Embedding, Database - an API designed by Microsoft for accessing different types of data stores in a uniform manner. (See http://en.wikipedia.org/wiki/OLE_DB)

ADO - ActiveX Data Object

ADO - ActiveX Data Object - a set of Component Object Model (COM) objects for accessing data sources. Provides a layer between programming languages and OLE DB. (See http://en.wikipedia.org/wiki/ActiveX_Data_Objects)

ODBC

ODBC - Open Database Connectivity - provides a standard software API method for using database management systems (DBMS). (See http://en.wikipedia.org/wiki/Open_Database_Connectivity)