Microsoft lays out SQL Server road map

The next version of the database server, code-named Kilimanjaro, is slated for release in the first half of 2010.

Microsoft Monday laid out its road map for SQL Server and a complement of add-ons it hopes will eventually redefine business intelligence and data warehousing.

The next version of the database server, code-named Kilimanjaro, is slated for release in the first half of 2010 with a focus on self-service and reporting capabilities for BI. Microsoft plans to have a "community technology preview" (CTP) available within the next 12 months.

The self-service features are wrapped up in a set of technologies code-named Gemini. Those technologies let users build BI applications that can access data across many sources, aggregate the data, build charts and reports and share the resulting applications via SharePoint.

Microsoft also plans to integrate the unified communications capabilities of Office Communications Server to aid the sharing of BI results.

Microsoft said much of the Gemini technology will be tied to Excel, allowing users of that desktop program access to the self-service analytics.

Microsoft made the announcements at its annual BI Conference, which is going on in Seattle this week and is expected to draw 2,500 users and partners.

The company's acquisitions in the BI market and its stated intentions to expand BI capabilities on the back of its popular SQL Server have been shaking up the market in the past six months.

Giants such as Business Objects/SAP, Cognos/IBM, Hyperion/Oracle are among the BI heavyweights with an eye on Microsoft.

A report by Gartner earlier this year said Microsoft still "lags behind pure-play vendors in terms of metadata management, reporting, and dashboard and ad hoc query capabilities."

Microsoft plans to systematically address those deficiencies.

The immediate goal is to extend its BI tools and software so they are more accessible to users, especially those using Excel and SharePoint.

With Gemini, Microsoft hopes to bring BI to users without sacrificing IT control.

"One important thing about Gemini is managed self-service," says Fausto Ibarra, director of product management for SQL Server. "Managed means IT is in control of the process where today end-users use Excel without control of IT or without control on data."

With Gemini, IT will be able to see how data is being shared, will have control of security on the data, and will make data sources available to users.

Those sources could include ERP data, mainframe applications and independent software vendor programs.

Another key feature of Gemini is in-memory BI, which analyzes large amounts of data in memory in order to speed performance.

At the conference, the company also unveiled plans for a highly scalable database technology code-named Madison that would be available in an appliance. Madison integrates SQL Server with technology the company acquired when it bought DataAllegro earlier this year.

DataAllegro developed large-volume data warehousing appliances, and Microsoft hopes to scale Madison to handle hundreds of terabytes of data. At the conference, Microsoft showed a demo using 1 trillion rows of data.

The company also plans to use data quality technology acquired when it bought Zoomix in July to enhance the quality of available information. Microsoft would only say the technology will come in "future versions" of SQL Server.

CTPs of Madison will roll out in the next 12 months with the appliances available in the first half of 2010. Dell, HP, Unisys, Bull Systems and EMC have signed on as hardware partners.

Join the newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags SQL

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

John Fontana

Network World
Show Comments

Cool Tech

SanDisk MicroSDXC™ for Nintendo® Switch™

Learn more >

Breitling Superocean Heritage Chronographe 44

Learn more >

Toys for Boys

Family Friendly

Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K

Learn more >

Stocking Stuffer

Razer DeathAdder Expert Ergonomic Gaming Mouse

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Walid Mikhael

Brother QL-820NWB Professional Label Printer

It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?