HomeApplianceMicrosoft SQL Server Parallel Data Warehouse (PDW) Explained

Comments

Microsoft SQL Server Parallel Data Warehouse (PDW) Explained — 36 Comments

  1. Pingback:Microsoft SQL Server Reference Architecture and Appliances | James Serra's Blog

  2. Pingback:Microsoft's Data Warehouse offerings | James Serra's Blog

  3. Pingback:Microsoft Data Warehouse Offerings « Garrett Edmondson

  4. Pingback:Reduce heap table fragmentation | James Serra's Blog

  5. Pingback:products | Pearltrees

  6. Pingback:SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3) | James Serra's Blog

  7. Pingback:SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse « The SQL Pro

  8. Pingback:PASS 2012 Announcements | James Serra's Blog

  9. Pingback:SQL Server Parallel Data Warehouse (PDW) 介绍 | 架构(architecture.riaos.com)

  10. Hi James,

    I believe your following statement is somewhat incorrect.
    “MPP is also available from other companies such as EMC Greenplum, Teradata, Oracle Exadata, HP Vertica, and IBM Netezza, but those use proprietary systems, where PDW can be used with commodity hardware, providing a much lower cost per terabyte.”
    I believe Terada and Vertica utilize unmodified commodity hardware while MS PDW requires specially configured proprietary HP or Dell hardware.

    Thanks.
    Dick Schneider

    • Hi Dick

      All the hardware in a Dell or HP PDW is commodity. On one of my clients, we repurposed a piece of old kit from a V1 appliance for other workloads after we upgraded.

      Configured specifically, yes. But not custom hardware like the Netezza FPGAs

  11. Pingback:Parallel Data Warehouse (PDW) Version 2 - SQL Server Blog - SQL Server - Telligent

  12. Pingback:Parallel Data Warehouse (PDW) Version 2 | James Serra's Blog

  13. Hello,

    As you said, Dimension tables get replicated and Fact tables get distributed across the the nodes in PDW. Is the data stored in same manner in Hadoop HDFS?

  14. Pingback:SQL Servers Big Brother – Parallel Data Warehouse | uxcps information management blog

  15. Pingback:SQL Server Data Tools (SSDT) – January 2014 update | James Serra's Blog

  16. Pingback:SQL Server Data Tools (SSDT) – January 2014 update - SQL Server - SQL Server - Toad World

  17. Pingback:Why I just became a Microsoft Employee | James Serra's Blog

  18. Pingback:PolyBase explained | James Serra's Blog

  19. Pingback:PolyBase explained - SQL Server - SQL Server - Toad World

  20. Pingback:What is HDInsight? | James Serra's Blog

  21. Pingback:Parallel Data Warehouse « NGBI

  22. Pingback:Madison ermittelt weiter… « NGBI

  23. Pingback:Real-time query access with PDW | James Serra's Blog

  24. Pingback:Real-time query access with PDW - SQL Server - SQL Server - Toad World

  25. Pingback:What is HDInsight? - SQL Server - SQL Server - Toad World

  26. Pingback:Parallel Data Warehouse (PDW) benefits made simple - SQL Server - SQL Server - Toad World

  27. Pingback:Parallel Data Warehouse (PDW) benefits made simple | James Serra's Blog

  28. Pingback:Parallel Data Warehouse (PDW) AU1 released | James Serra's Blog

  29. Pingback:Parallel Data Warehouse (PDW) AU1 released - SQL Server - SQL Server - Toad World

  30. Pingback:Parallel Data Warehouse (SQL Servers Big Brother) Presentation | uxcps information management blog

  31. Pingback:What is SQL Server Parallel Data Warehouse? | XL-UAT

  32. I wouldn’t call Oracle Exadata an MPP device. Quoting from one of their White Papers they say: “The Exadata Database Machine X2-8 combines an outstanding scale-up and scale-out architecture by delivering a grid infrastructure containing large SMP database servers and an Exadata storage grid.”; and I don’t see MPP mentioned in any of their documentation. They have a storage grid, and the storage servers are massively parallel – and there’s nothing new about that. The processors are still SMP, and only a few of them. Still; Oracle can achieve scale-out to 504 TB as well as high performance using columnar data-store without any of the problems of MPP. It’s a good technology, ideal for OLAP (and even OLTP); but wasted, in my opinion, on Data Warehousing. MPP prices should drop dramatically once competition kicks in and we learn how to use it properly.

  33. Pingback:Data Parallel Address Architecture | Easy Architecture Fan

  34. Pingback:New year, new role, and new book – SQLServerCentral

  35. Hi,

    I want to insert 6-10 millions record from one table to another table in Sql Server 2012 PDW quickly…
    so what is the best way to do it within couple of min..

Leave a Reply to Richard Schneider Cancel reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>