APS Best Practice: How to Optimize Query Performance by Minimizing Data Movement

by Rob Farley, LobsterPot Solutions The Analytics Platform System, with its MPP SQL Server engine (SQL Server Parallel Data Warehouse) can deliver performance and scalability for analytics workloads that you may not have expected from SQL Server. But there are key differences in working with SQL Server PDW and SQL Server Enterprise Edition that one… Read more

Introducing the Microsoft Analytics Platform System – the turnkey appliance for big data analytics

At the Accelerate your Insights event last week, Satya Nadella introduced the new Microsoft Analytics Platform System (APS) as Microsoft’s solution for delivering “Big Data in a box.” APS is an evolution of our SQL Server Parallel Data Warehouse (PDW) appliance which builds upon the high performance and scale capabilities of that MPP version of… Read more

O’Reilly Strata: Busting Big Data Adoption Myths with Halo 4–Part 3

Structured or unstructured – what to store? How about all of it? I spoke at the O’Reilly Strata Conference last year and am back again this year to share thoughts about big data. It’s been a remarkable year for Microsoft’s data platform team. While we’ve had a long history in the data space, last year… Read more

Seamless insights on structured and unstructured data with SQL Server 2012 Parallel Data Warehouse

In the fast evolving new world of Big Data, you are being asked to answer a new set of questions that require immediate responses on data that has changed in volume, variety, complexity and velocity. A modern data platform must be able to answer these new questions without costing IT millions of dollars to deploy… Read more

Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment

We’ve recently been talking about what goes on behind the scenes with SQL Server. While we love to share stories about the nuts and bolts of what we do, our favorite stories are those showing how customers are using our technology to tackle business challenges and achieve their goals. A great example is Hy-Vee, one… Read more

Simplifying Management of PDW Appliances with System Center

SQL Server Parallel Data Warehouse (PDW) is a highly scalable appliance for enterprise data warehousing that enables massive scalability, predictable performance, and complete BI solution at low cost. PDW ships with a web based management console for monitoring the health of PDW appliance and resolving issues. The appliance model and this web based tool simplify… Read more

Dell Parallel Data Warehouse Appliance Announced @PASS Summit!

We’ve wrapped up getting SQL Server Parallel Data Warehouse on Dell hardware and proud to announce the Dell Parallel Data Warehouse Appliance that includes Dell PowerEdge R610 Servers and Dell PowerVault MD36xxF series high density storage. The Dell Parallel Data Warehouse Appliance is a rack solution with a single control rack and one to four… Read more

Microsoft ships CTP of Hadoop Connectors for SQL Server and Parallel Data Warehouse

Two weeks ago, Microsoft announced its commitment to Hadoop and promised to release new connectors to promote interoperability between Hadoop and SQL Server. Today we are announcing the availability of the Community Technology Preview (CTP) of two connectors for Hadoop: The first is a Hadoop connector for SQL Server Parallel Data Warehouse (PDW) that enables… Read more

Microsoft ships the final Technology Preview for SQL Server 2008 R2 Parallel Data Warehouse

  Today, Microsoft shipped the final Technology Preview of SQL Server 2008 R2 Parallel Data Warehouse and announced the Technology Adoption Program (TAP). Customers interested in joining the Technology Preview or the TAP, that officially starts now, should email mdsontap@microsoft.com. This is a significant milestone on the integration of DATAllegro technology as Parallel Data Warehouse… Read more