Part 1: Creating a Recoverable Database
Part 2: Creating a Reliable and Automated Backup Strategy
Part 3: Designing Tables that Scale, Best Practices in Data Types and Initial Table
Part 4: SQL Server Indexing Best Practices
Part 5: SQL Server Index Defrag Best Practices
Part 6: SQL Server Mixed Workloads, Secondary Databases, Locking and Isolation
MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10
MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10
MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10
MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10
MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10
MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10
SQL Server Resources from KIMBERLY…
http://www.sqlskills.com/BLOGS/KIMBERLY/category/Resources.aspx