News

Microsoft SQL Server Fast Track Data Warehouse 3.0 Debuts

Microsoft announced a new set of reference architectures on Monday that are designed for partners building Fast Track data warehouse products.

The company rolled out version 3.0 of its SQL Server Fast Track Data Warehouse at this week's TDWI World Conference in Las Vegas. According to Microsoft's announcement, this release allows partners to "build and test their own Reference Architectures." Though Microsoft follows up by validating its partners' Fast Track configurations, it maintains that version 3.0 enables greater product differentiation for hardware partners.

Overall, Microsoft offers three software solutions for data warehouse implementations: SQL Server 2008 R2, Parallel Data Warehouse and Fast Track Data Warehouse.

The Fast Track products consist of preconfigured servers using SQL Server 2008 R2 Enterprise edition. Microsoft claims that users can scale the solution upward, moving from Fast Track (handling tens of terabytes workloads) to SQL Server 2008 R2 Parallel Data Warehouse (handling hundreds of terabytes workloads).

Fast Track version 3.0 enables configurations that can scale upward to 80 terabytes "on a single 8-processor server," Microsoft's announcement states. HP currently offers a configuration on an eight-processor server with a "peak data throughput of up to 15GB/s," according to Microsoft.

Current hardware partners offering SQL Server Fast Track Data Warehouse include Bull, Dell, EMC, HP and IBM. Microsoft also indicated in its announcement that it is working with some new partners on the product, including Cisco Systems, Fujitsu and Hitachi Data Systems. NetApp and EMC are working as storage provider vendors on some of the configurations.

On top of the hardware partner announcements, WhereScape claims to be the first independent software vendor to offer a solution built for Microsoft's Fast Track Data Warehouse 3.0 architecture. The company is now offering its WhereScape RED integrated development environment, which can be used to build SQL Server data warehouses and analysis services cubes.

Other data warehouse software vendors have tried the approach of allowing hardware vendors to tweak the software reference architecture, according to James Kobielus, senior analyst at Forrester Research. He cited Oracle's efforts a few years ago in working with IBM and Dell/EMC as an example, but added that Oracle now emphasizes its own software running on Oracle-Sun hardware as part of its Exadata product family.

"Microsoft remains far more hardware partner-focused than Oracle in the EDW [enterprise data warehousing] appliance arena," Kobielus stated in an e-mail. "In fact, HP (which was Oracle's hardware partner on Exadata v1 in 2008, and then quickly abandoned) is Microsoft's primary hardware for its high-end PDW [parallel data warehousing] appliances, and is one of several under the Fast Track program for lower-capacity, midmarket-focused EDW appliances."

Microsoft made the "leaders" category in a report authored by Kobielus and published this month. The report, "The Forrester Wave: Enterprise Data Warehousing Platforms, Q1 2011," includes a chart comparing the strength of a software vendor's current offerings with the overall strength of its strategies. The leaders include Teradata, Oracle, Sybase (SAP), IBM, SAP, EMC Greenplum and Netezza (IBM), Microsoft and Vertica Systems.

The report, available here, describes the rankings in great detail. Kobielus also talked about his findings recently in a blog post.

About the Author

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

Featured

  • Microsoft Offers Support Extensions for Exchange 2016 and 2019

    Microsoft has introduced a paid Extended Security Update (ESU) program for on-premises Exchange Server 2016 and 2019, offering a crucial safety cushion as both versions near their Oct. 14, 2025 end-of-support date.

  • An image of planes flying around a globe

    2025 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.

  • Notebook

    Microsoft Centers AI, Security and Partner Dogfooding at MCAPS

    Microsoft's second annual MCAPS for Partners event took place Tuesday, delivering a volley of updates and directives for its partners for fiscal 2026.

  • Microsoft Layoffs: AI Is the Obvious Elephant in the Room

    As Microsoft doubles down on an $80 billion bet on AI this fiscal year, its workforce reductions are drawing scrutiny over whether AI's ascent is quietly reshaping its human capital strategy, even as official messaging avoids drawing a direct line.