Published: July 29, 2009 | Updated: May 25, 2010
Download the SQL Server Guide
About This Guide
The Infrastructure Planning and Design (IPD) guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 helps organizations address key design decisions and confidently plan the efficient implementation of a SQL Server infrastructure. The tasks addressed in this guide help technical decision makers identify the appropriate SQL Server roles needed as well as determine the infrastructure components, server placement, and fault-tolerance configuration necessary to meet planning requirements. By using this guidance, organizations can make efficient planning and optimal design decisions for their SQL Server infrastructures.
Figure 1. SQL Server 2008 and SQL Server 2008 R2 infrastructure decision flow
In More Detail
The SQL Server 2008 R2 Guide includes the following content:
- Step 1: Determine the Project Scope
- Step 2: Determine Which Roles Will Be Required
- Step 3: Design the SQL Server Database Engine Infrastructure
- Step 4: Design the SQL Server Integration Services Infrastructure
- Step 5: Design the SQL Server Analysis Services Infrastructure
- Step 6: Design the SQL Server Reporting Services Infrastructure
- Step 7: Design the SQL Server Master Data Services
Join the Beta
Subscribe to the IPD beta program and we will notify you when new beta guides become available for your review and feedback. They are open beta downloads. If you are not already a member of the IPD beta program, and would like to join, follow these steps:
Go here to join the IPD beta program: https://connect.microsoft.com/InvitationUse.aspx?ProgramID=1587&InvitationID=IPDM-QX6H-7TTV&SiteID=14
If the link does not work for you, copy and paste it into the web browser address bar.
Sign in using a valid Windows Live ID.
Enter your registration information.
Continue to the IPD beta program page, scroll down to Infrastructure Planning and Design, and click the link to join the IPD beta program.
Already a member of the IPD beta program? Go here to get the latest IPD beta downloads: https://connect.microsoft.com/content/content.aspx?ContentID=6556&SiteID=14
Community and Feedback
Please send questions or comments about this guide to IPDfdbk@microsoft.com.
About Solution Accelerators
Solution Accelerators are authoritative resources that help IT pros plan, deliver, operate, and manage IT systems that address real-world scenarios. Solution Accelerators provide free, prescriptive guidance and automation to accelerate cross-product integration, core infrastructure development, and other enhancements.
Sign up to receive the Solution Accelerator Notifications newsletter so that you can stay informed about new Solution Accelerator releases and updates. The newsletter covers such areas of interest as:
- Communication and collaboration
- Security, data protection, and recovery
- Operations and management