SQL Server

Published: July 29, 2009   |   Updated: May 25, 2010

 

Download the SQL Server Guide

Launch the download of the IPD guide for Microsoft SQL Server 2008 and SQL Server 2008 R2.

Launch the download of the entire Infrastructure Planning and Design Guide series.

Visit the Download Center to select another guide in the Infrastructure Planning and Design Guide series.

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.

SQL Server 2008 decision flow

 

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

Related Resources

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:

  1. 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.

  2. Sign in using a valid Windows Live ID.

  3. Enter your registration information.

  4. 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
  • Deployment
  • Operations and management

Download the SQL Server Guide

Launch the download of the IPD guide for Microsoft SQL Server 2008 and SQL Server 2008 R2.

Launch the download of the entire Infrastructure Planning and Design Guide series.

Visit the Download Center to select another guide in the Infrastructure Planning and Design Guide series.