Microsoft Parallel Data Warehouse Overview

Microsoft Parallel Data Warehouse is the #6 ranked solution in our list of top Data Warehouse tools. It is most often compared to Microsoft Azure Synapse Analytics: Microsoft Parallel Data Warehouse vs Microsoft Azure Synapse Analytics

What is Microsoft Parallel Data Warehouse?

The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

Microsoft Parallel Data Warehouse is also known as Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse.

Microsoft Parallel Data Warehouse Buyer's Guide

Download the Microsoft Parallel Data Warehouse Buyer's Guide including reviews and more. Updated: April 2021

Microsoft Parallel Data Warehouse Customers

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe

Microsoft Parallel Data Warehouse Video

Filter Archived Reviews (More than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
BI Business Analyst at a transportation company with 1,001-5,000 employees
Vendor
It handles high volumes of data very well. Though, it needs more compatibility with common BI tools.

What is our primary use case?

Analysing large volumes of data collected from auto ticket barriers at railway stations.

How has it helped my organization?

It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.

What is most valuable?

It handles high volumes of data very well.

What needs improvement?

It needs more compatibility with common BI tools.  It does not work well with normal ETL tools. Some functions do not work.

For how long have I used the solution?

One to three years.
Teradata DBA / Parallel datawarehouse DBA at a tech services company with 10,001+ employees
Real User
Concurrency issues forced the customer to use the raw DB as a secondary solution

What is our primary use case?

We are using PDW as an EDW solution.

How has it helped my organization?

It helped, initially, as a replacement for our DW DB, but later on faced issues due to concurrency, which forced the customer to use the DB as a secondary solution.

What is most valuable?

Nothing specific, comparable to other solutions.

What needs improvement?

Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution. They need to improve the metadata being captured to a greater duration.

For how long have I used the solution?

One to three years.
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2021.
501,499 professionals have used our research since 2012.
Business Intelligence evangelist at a hospitality company with 10,001+ employees
Vendor
Gives us the ability to distribute large data sets across nodes.

What is most valuable?

MPP processing gives us the ability to distribute large data sets across nodes.

How has it helped my organization?

We delivered a data warehouse for Contactless and Oyster at TFL.

What needs improvement?

Improve the speed of processing replicated tables.

For how long have I used the solution?

We have been using this solution for years.

What do I think about the stability of the solution?

There were stability issues when the product was in beta.

What do I think about the scalability of the solution?

There were scalability issues in that there is a limit to 32 concurrent queries.

How are customer service and technical support?

Technical support is good.

Which solution did I use previously and why did I switch?

We switched from the standard…
Solution Architect at a comms service provider with 11-50 employees
Vendor
It has inherent Hadoop integration that can refer HDFS by means of external tables, but there's a bottleneck if there are many partitions in the baseline table.

What other advice do I have?

This is a great product for big data analytics as it can challenge other MPPs quite well.
Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees
Vendor
Microsoft PDW History
Originally published at https://www.linkedin.com/pulse/microsoft-pdw-history-datallegro-stephen-c-folkerts Microsoft SQL Server Parallel Data Warehouse (PDW) is the result of the DATAllegro acquisition in 2008 for roughly $238M. Datallegro was the invention of Stuart Frost to compete with Netezza which is now IBM PureData System for Analytics. Stuart Frost founded DATAllegro in 2003, was CEO of the company from the beginning, and specified the architecture of the product.Netezza came to market with a compelling value proposition. It leveraged an open source Postgres DBMS. It used an appliance business model to create a tightly integrated software and hardware stack, removing a significant area of complexity for DBAs and other system staff. It shifted to sequential I/O…
Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees
Vendor
It's a scale out, MPP shared nothing architecture where there are multiple physical nodes.
Originally published at https://www.linkedin.com/pulse/microsoft-parallel-data-warehouse-pdw-stephen-c-folkerts What’s the Difference Between Microsoft’s Parallel Data Warehouse (PDW) and SQL Server? In this post, I’ll provide an in-depth view of Microsoft SQL Server Parallel Data Warehouse (PDW) and differentiate PDW with SQL Server SMP. SQL Server is a scale up, Symmetric Multi-Processing (SMP) architecture. It doesn’t scale out to a Massively Parallel Processing (MPP) design. SQL Server SMP runs queries sequentially on a shared everything architecture. This means everything is processed on a single server and shares CPU, memory, and disk. In order to get more horse power out of your SMP box, or as your data grows, you need to buy a brand new larger more expensive server…
Developer at a tech consulting company with 51-200 employees
Consultant
It offers high performance & low cost Data Warehousing over industry latest hardware

What other advice do I have?

Both hardware and software support is provided by Microsoft.
Consultant at a tech consulting company with 51-200 employees
Consultant
Parallel Data Warehouse (PDW) POC – lessons learned
The first version of Microsoft’s Parallel Data Warehouse is out for a while, now I had the chance to get my hands on it during a customer POC. Because PDW is an appliance solution the software is hardware bounded. You can’t download and install PDW on a normal server, you need the right hardware which needs to be MPP capable. Currently there are only 2 vendors providing PDW hardware, HP and DELL. For all of you who need a further introduction into PDW I can recommend my past blog posts: Parallel Data Warehouse – Overview Parallel Data Warehouse – Architecture Components Parallel Data Warehouse – Hardware Components Customer Requirements So let’s go back to the customer POC. My customer currently has a Data Warehouse solution build on SQL Server. The following list…
CEO at a tech services company with 501-1,000 employees
Consultant
We examined SAP Data Warehouse and IBM Data Warehouse but SQL Data Warehouse provided a more extensive way of integrating data.

What other advice do I have?

• It comes as a special tool of cleaning data through the data transformation process where data is extracted from many sources before it is assembled and consolidated to form a single database. This is the main factor that led my company to choose SQL Data Warehouse as the special tool to consolidate relational databases. Close examination was done on SAP Data Warehouse and IBM Data Warehouse but SQL Data Warehouse provided a more extensive way of integrating data. I personally value the role that SQL Data Warehouse has contributed in achieving the goals of business intelligence. Users will…