Skip to content

SQL Server 2012 PDW: Game on!

2013 March 11
by Brian Mitchell

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

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.

PolyBase

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.

Want to know more about what PolyBase can do? Check out this PolyBase landing page, including this PolyBase datasheet.

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

http://passbaconference.com/Sessions/SessionDetails.aspx?sid=4223#.UTjTPUwo6fA

Relational and Non-relational Data Living in Peace and Harmony, Artin Avanes

http://passbaconference.com/Sessions/SessionDetails.aspx?sid=4216#.UTjTf0wo6fA