An insight into SQL Server 2008 R2 Parallel Data Warehouse (PDW)

There’re several exciting features included in SQL Server 2008 R2 including PowerPivot for Sharepoint and Excel, Master Data Services for data consistency and StreamInsight for processing high volumes of event stream data, but “the most exciting among two new editions is “SQL Server 2008 R2 Parallel Data Warehouse (PDW),” which’s an appliance based solution using […]

There’re several exciting features included in SQL Server 2008 R2 including PowerPivot for Sharepoint and Excel, Master Data Services for data consistency and StreamInsight for processing high volumes of event stream data, but “the most exciting among two new editions is “SQL Server 2008 R2 Parallel Data Warehouse (PDW),” which’s an appliance based solution using vendors including EMC to provide a highly scalable data warehouse. PDW uses a massively parallel processing (MPP) architecture that scales from terabytes to petabytes while delivering high performance and using SQL Server additional business intelligence features and functionality. By including EMC’s industry recognized high performance and highly available arrays into PDW solution you’ve a dedicated appliance that has the power of Microsoft and EMC to handle some of the largest most complex data warehouse environments,” writes Adrian Simays.

[Source]