Microsoft Parallel Data Warehouse Hits Metal This Month

Release on HP hardware marks integration of technology from DATAllegro acquisition into the flagship Microsoft database technology family.

The Parallel Data Warehouse (PDW) Edition of Microsoft SQL Server 2008 R2 will soon see the light of day. It will appear on hardware from Hewlett-Packard Co. this month.

The new HP Enterprise Data Warehouse Appliance will be available sometime in mid-December, Microsoft announced at the Professional Association for SQL Server (PASS) Summit event, which was held last month in Seattle. The product will use the Microsoft SQL Server 2008 R2 PDW Edition solution, formerly known by its "Madison" code name.

Madison is Redmond's reworking of the DATAllegro massive parallel processing product that Microsoft acquired nearly two years ago. It represents the last of the Microsoft SQL Server 2008 R2 editions to become a full-fledged product. The delay in release may reflect Microsoft's caution with a complex product.

"There is more to PDW than just a release of [SQL Server] 2008 R2 on hardware," said Wes Miller, a Directions on Microsoft analyst, in an e-mail from the PASS event. "Tuning and changes within SQL -- to partition the data -- are there as well."

On top of the HP product build, Microsoft is working with other possible hardware partners. Bull SAS was the second possible hardware vendor mentioned.

Microsoft is somewhat late to the competition with its massive parallel processing technology in PDW, notes James Kobielus, a senior analyst with Forrester Research Inc. He says that such technologies have already been deployed in products from companies such as Greenplum and Netezza Corp. Those companies, in turn, have been scooped up by bigger players. EMC Corp. announced the acquisition of Greenplum in July, while IBM Corp. indicated in September that it's acquiring Netezza.

"Microsoft is playing catch up," Kobielus says. "What they've rolled out now with parallel data warehousing is a bit late to the game, and they know it."

Microsoft has had clustering capabilities in SQL Server for a while, he explains, but the scalability part was lacking, and that's what the DATAllegro technology brings.

Scalability in PDW means handling tens of terabytes of data and then moving to hundreds of terabytes worth, according to Microsoft.

The price per terabyte will start at $13,228 (including estimated hardware cost), according to a Microsoft spokesperson.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.


  • Microsoft In Talks To Acquire TikTok

    A deal between Microsoft and Beijing-based ByteDance is in the works that would have Microsoft acquiring some of ByteDance's holdings in the TikTok social media service.

  • Some Cortana Features Ending as Part of Microsoft 365 Shift

    Microsoft may be promoting Cortana more as a Microsoft 365 business perk, but the digital assistant will soon see several of its capabilities falling out of support.

  • 2020 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss. (Now updated with COVID-19-related event changes.)

  • Tasks in Teams Starts Rolling Out to Some Microsoft 365 Users

    Tasks in Teams, which pulls together information from Microsoft task-creation apps like Planner and To Do, has started rolling out to "a small group" of Microsoft 365 users.

RCP Update

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.