SQL Server 2012 PDW: Game on!
Ok kids, time to get excited. There is a great deal of activity around SQL Server 2012 Parallel Data Warehouse. As of March 1st, you can order what was previously known as “PDW V2”. This post will be pointers to several other pages and posts providing good information on the product.
The SQL Server PDW landing page has been updated with information around the 2012 product.
What’s New in SQL Server 2012 Parallel Data Warehouse
Up to 50x performance gains with the xVelocity updateable columnstore.
Up to 100x performance gains over legacy warehouses.
Seamless integration with “Big Data” using PolyBase.
Multi-petabyte data capacity.
2.5x lower price per terabyte than SQL Server 2008 R2 PDW and lowest price per terabyte in industry.
I’ll do some separate posts on the specs of the hardware and the like in the near future. What is clear here is that SQL Server PDW now fits much more punch in a much smaller footprint. A single data rack appliance now literally comes in a single rack whereas before it too two racks (control + compute). This smaller footprint means a much lower cost for the appliance even as PDW maintains all the high availability standards you come to expect from an appliance. I’ll tell you this much right now: This is a game changer for Microsoft and SQL Server PDW.
In a nutshell, PolyBase is a technology in SQL Server 2012 PDW that allows you to query both data from both within your SQL Server PDW and Hadoop environments at the same time. You can even join that data together for new insights you can’t do easily today.
I’m sure I’ll do a technical rundown of PolyBase in a future post, but for now you’ll have to check out some material posted by Microsoft:
Want to know more about who created PolyBase? There is a cool blog post with interviews of Jim Gray’s team at the University of Wisconsin.
Is there more?
Did you miss Ted Kummert’s Keynote on SQL Server 2012 PDW from the PASS Summit? Watch this video.
PASS Business Analytics Conference
There are a couple important session on SQL Server 2012 PDW at the PASS Business Analytics Conference. I’ll be there, will you?
PDW Architecture Gets Real: Customer Implementations, Brian Walker and Murshed Zaman
Relational and Non-relational Data Living in Peace and Harmony, Artin Avanes