A Collection of our own acticles specifically on SQL Server:

SQL Server Programming Environment
SQL Server Indexes
SQL Server Index Optimization
SQL Server Index Performance
SQL Server Security
SQL Server Profiler
SQL Server Stored Procedures
SQL Server System Stored Procedures
SQL Server Triggers
SQL Server Transact SQL Tools
SQL Server 2000 Data Types
SQL Server Managing Data
SQL Server Data Transformation Services (DTS)
SQL Server Bulk Copy Program (BCP)
SQL Server Replication

Paladin Consultants, Inc. provides excellent database designs with memorable web interfaces. They also have a few excellent articles on design philosophy, and the like.

Two articles on database design Database Design and Technical Complexities of Database Design

There is some useful information at StoredProcedure.com with links and articles on client server technology and access to information.

A guide and tutorial on the Rules of Data Modelling and Normalization

Dr. E.F. Codd's 12 Rules for defining a fully relational database.