Recommended Articles for a Developer – 029

SQL Server And Business Intelligance

SQL Server

Database Design Follies: NULL vs. NOT NULL – SQLServerCentral
SQL subqueries – CodeProject
Create SQL Server Database Unit Tests – CodeProject
Overcoming the OPENQUERY Record Limit for AD – SQLServerCentral

Indexes and Tuning

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes – SQLServerCentral
T-Sql Optimization Tips – CodeProject

Stored Procedures, Triggers, Functions

Stored Procedures Best Practices – CodeProject