Best Practices for Data Warehousing with SQL Server 2008 R2

Writers: Mark Whitehorn (Solid Quality Mentors), Keith Burns (Microsoft), Eric N Hanson (Microsoft)

Technical Reviewer: Eric N. Hanson (Microsoft)

Published: December 2010

Applies To: SQL Server 2008 R2, SQL Server 2008

Summary: There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008 R2. The application of best practices to a data warehouse project is one of the best investments you can make toward the establishment of a successful Business Intelligence infrastructure.

To review the document, please download the Best Practices for Data Warehousing with SQL Server 2008 R2 Word document.

• Ask a question in the SQL Server 2008 Forums
• Send Feedback