SQL Server Logo

Technical Reference Guides for Designing
Mission-Critical DW Solutions

The guides in the series, Technical Reference Guides for Designing DW Solutions, assist with the planning and design of data warehouse (DW) solutions that use SQL Server. These guides reflect the knowledge gained by Microsoft while working with customers on mission-critical deployments. Each guide provides not only the key technical concepts and information helpful for design, but also “lessons learned,” best practices, and references to customer case studies. Most of the information in these guides tends not to be version specific and spans concepts consistent from Microsoft SQL Server 2005 through Microsoft SQL Server 2008 R2.

Use these technical reference guides after you have made the conceptual architectural decisions to address specific business needs and are ready to work through the technical design alternatives to choose a solution.

To access these guides, you may use the visual hierachy (i.e., image map) that provides a visual representation of the relationship between the guides or through a bulleted hierarchical list.

To open a guide, click on the corresponding text in the following diagram.

SQL Server---a Technical Reference Guide for Designing DW Solutions SQL Server Data Warehousing (DW)---a Technical Reference Guide for Designing DW Solutions Massively Parallel Processing (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Symmetric Multi-Processing (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Reference Architecture (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Custom Architecture (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Data Sources (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Microsoft Data Sources (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Data from Other RDBMS Vendors (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Extract, Transform, and Load (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Initial or One-Time Data Loading (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Incremental Data Loads (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Real-Time Data Loading (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Data Warehouse Consumers (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Analysis Services as a Data Warehouse Consumer (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Reporting Services as a Data Warehouse Consumer (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions PowerPivot as a Data Warehouse Consumer (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Third-Party Data Warehouse Consumers (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Data Center Optimization (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Backup & Restore (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Database Maintenance (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Software Maintenance (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Version Upgrade (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Agents & Jobs (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Monitoring (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Compliance (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Governance (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Security (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions High Availability & Disaster Recovery (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Database Mirroring (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions Failover Clustering (SQL Server DW)---a Technical Reference Guide for Designing DW Solutions DW Technical Reference Guides --- Visual Hierarchy