Category Archives: PDW

Hadoop and Data Warehouses

I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution.  Hadoop should not be a replacement for a data warehouse, but rather should augment/complement a data warehouse.  Hadoop and a data warehouse … Continue reading

Posted in Data warehouse, Hadoop, PDW, SQLServerPedia Syndication | 2 Comments

What is the Microsoft Analytics Platform System (APS)?

Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW).  It is not really a new product, but rather a name change due to a new feature in Appliance Update 1 (AU1) of PDW.  That new … Continue reading

Posted in PDW, SQLServerPedia Syndication | 1 Comment

Parallel Data Warehouse (PDW) AU1 released

Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason is due to frequent upgrades to the hardware and software.  About every six months there is an appliance update, which … Continue reading

Posted in PDW, SQLServerPedia Syndication | 2 Comments

Parallel Data Warehouse (PDW) benefits made simple

I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret.  So let me give a 10,000 foot overview on what PDW is and its benefits.  Keep in mind the purpose for a PDW is for … Continue reading

Posted in PDW, SQLServerPedia Syndication | 2 Comments

Real-time query access with PDW

The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and the Tabular model (In-Memory and DirectQuery modes).  The big benefit of using ROLAP or DirectQuery is you get real-time query access … Continue reading

Posted in PDW, SQLServerPedia Syndication, SSAS | Leave a comment

Introduction to Hadoop

Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in a distributed fashion (via MapReduce) across clusters of commodity hardware on a storage framework (HDFS).  Hadoop uses a simplified programming model.  The … Continue reading

Posted in Hadoop, PDW, SQLServerPedia Syndication | 7 Comments

What is HDInsight?

There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but lives on in a different form).  Both were developed in partnership with Hadoop software developer and distributor Hortonworks and were made … Continue reading

Posted in Hadoop, PDW, SQLServerPedia Syndication | 4 Comments

PolyBase explained

PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop.  It is designed to enable queries across relational data stored in PDW and in non-relational Hadoop data that is stored in the Hadoop Distributed File … Continue reading

Posted in Hadoop, PDW, SQLServerPedia Syndication | 8 Comments

Why I just became a Microsoft Employee

I have been an independent consultant (IC) for quite a while now.  In an amazing number of coincidences, or just plain fate, in a matter of 17 days I went from hearing about a job opening at Microsoft to accepting their … Continue reading

Posted in Career, PDW, SQLServerPedia Syndication | 25 Comments

Parallel Data Warehouse (PDW) Version 2

Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st).  The official name is Microsoft SQL Server 2012 Parallel Data Warehouse. Info on HP’s version: HP AppSystem for Microsoft SQL Server 2012 Parallel … Continue reading

Posted in PDW, SQLServerPedia Syndication | 5 Comments