Fast Track Data Warehouse Reference Guide for SQL Server 2012

I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances).  That was version 3.0 of the reference configuration that was for SQL Server 2008 R2.  Just released is version 4.0 for SQL Server 2012 (download).

The following table provides a list of notable changes or updates:

Description Version Note
SQL Server 2012 4.0 Links to other SQL Server Best Practices documents
SQL Server 2012 4.0 Benchmarking and validation
SQL Server 2012 4.0 Memory requirements
SQL Server 2012 4.0 xVelocity memory-optimized columnstore indexes
SQL Server 2012 4.0 Solid state storage
SQL Server 2012 4.0 Validation and columnstore indexes
SQL Server 2012 4.0 Validation of baseline I/O

More Info:

SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012

Microsoft Data Warehouse Features

SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd

Microsoft SQL Server 2012 Fast Track Data Warehouse 4.0: HP ProLiant DL380p Gen8

Fast Track Reference Architecture Recording – Friday Tech Call

Not Your Grandmother’s Data Warehouse

SQL Performance Tuning Test Results for Data Warehouse Architectures

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in Data warehouse, Fast Track, SQLServerPedia Syndication. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>