EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

SQL Industry News

SQL Server News

02/24/2009
Microsoft Looks to Push SQL Server Deeper into the Data Warehousing Space

Microsoft has partnered with a number of hardware vendors to create a new set of reference architectures aimed at cutting the complexity associated with creating data warehouses.

Microsoft officials say the Microsoft SQL Server Fast Track Data Warehouse is intended to give customers access to preconfigured industry-standard hardware from Hewlett-Packard, Dell and Bull. In addition, Microsoft officials said Microsoft is partnering with Avanade, Cognizant Technology Solutions, HP and Hitachi Consulting to provide solution templates and technical guidance to help customers create customized architectures for their data warehouse needs.

"This is basically a step towards appliance-sizing SQL Server for data warehousing … basically Microsoft taking on the responsibility for pretuning the database-to-hardware interface, which we've just found over the years to be a point of real complexity and difficulty for the typical DBA [database administrator]," said Stuart Frost, general manager of Microsoft's SQL Server Data Warehousing Product Unit.

The reference architectures will solve those problems, he said, and build on the foundation that Microsoft laid down with the purchase of DATAllegro in 2008. According to officials at Microsoft, the company is pushing ahead with plans to integrate DATAllegro's massively parallel processing technology with SQL Server 2008 in a project code-named Madison.

The offering is meant to increase Microsoft SQL Server 2008's scalability up to 32TB and to slash the time and effort required to deploy mission-critical projects. Through balanced configurations, the new reference architectures are designed to optimize all hardware components, delivering up to 200MB per second per central processing unit core, according to Microsoft. The hardware and reference architectures are available from Bull, Dell and HP starting at $13,000 per terabyte.

"With Microsoft SQL Server 2008 running on Dell PowerEdge servers, these new data warehousing solutions are able to scale from several terabytes to multi-tens of terabytes," Judy Chavis, director of Software Marketing and Business Development at Dell, said in a statement. "Soon, they'll be able to scale even higher. This industry-standard solution gives customers a cost-effective alternative to other proprietary business intelligence solutions available today."

Brian Prince

twitterfacebook