I had the chance to do a customer POC on a very early version of SQL Server 2012 Parallel Data Warehouse and like to share the new features for PDW as well as the impressive results we got. The good thing with this POC is, that we did the same POC also on the SQL Server 2008R2 version of PDW so we have a direct comparison on the results.
If you are not familiar with Parallel Data Warehouse I can suggest my further post list about PDW to get a step into it: https://dwjunkie.wordpress.com/pdw/
I will split this post into several topics that I will explain in more details in my next posts:
- What’s new in SQL Server 2012 PDW?
- Scope & Customer Expectations of the POC
- SQL Server 2008 R2 PDW vs. SQL Server 2012 PDW
- Performance Results and lessons learned (SSIS vs. TSQL, Querying, Cube Processing, Compression, Limitations, etc.)