Saturday, November 25, 2006

SQL Server - Best Practices Site Available On TechNet

Microsoft TechNet has a page named SQL Server - Best Practices; this site has white papers, scrips a toolbox and top 10 lists
From the site:
Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise from respected developers and engineers at Microsoft as they walk you through the specifics on solving particularly difficult issues.



Here is a preview of some of the material that is available right now:

Technical White Papers
Deep level technical papers on specific SQL Server topics that were tested and validated by SQL Development

• SQL Server 2005 Performance Tuning using Waits and Queues

• TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild

• Loading Bulk Data into a Partitioned Table

• DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005

• Database Mirroring Best Practices and Performance Considerations


Best Practices ToolBox
• Scripts and tools for performance tuning and troubleshooting SQL Server 2005


Top 10 Lists
Summary lists (usually consisting of 10 items) of recommendations, best practices and common issues for specific customer scenarios by the SQL Server Customer Advisory Team.

• Storage Top 10 Best Practices

• OLTP Top 6 Performance Issues for OLTP Applications


Best Practices in SQL Server Books Online• Best Practices for Replication Administration

• Replication Security Best Practices

A must for every SQL Server developer: SQL Server - Best Practices

1 comment:

Harry Fuecks said...

Thanks for the tip off. Someone needs to do a little QA on that page though.

The "Loading Bulk Data into a Partitioned Table" whitepaper links to "SQL Server 2005 Performance Tuning using Waits and Queues"

Meanwhile looks like some template variable substitution failed on "Best Practices ToolBox" section - all those links are broken (though fairly easy to figure out what they should be)