Microsoft unveils preview code for next SQL Server

The updates will help push BI capabilities to end users via SQL Server

Microsoft this week is giving developers an early peek at SQL Server 2008 R2, the next generation of its flagship database.

MSDN and TechNet subscribers got first dibs on Monday; the CTP (community technology preview) will be generally available Wednesday, Microsoft said.

[ Test Center: Microsoft SQL Server 2008 is the best SQL Server yet. ]

SQL Server 2008 R2 will help DBAs manage large-scale deployments and promote self-service BI (business intelligence), wherein end-users generate their own queries and reports with less involvement needed from IT staff, according to Microsoft.

"New wizards enable administrators to quickly set up a multi-server management environment in minutes -- no professional services required," Microsoft promised in an official blog post. DBAs will gain a range of capabilities for tracking their systems' resource usage and handling upgrades.

Meanwhile, a new version of Report Builder incorporates support for mapping data and "benefits power users that are looking for a more sophisticated authoring environment," the blog adds.

Overall, Microsoft is trying to push BI capabilities -- long the province of only some users due to the software's high cost -- to the masses by tying them to its widely used SharePoint collaboration platform and venerable Excel spreadsheet.

A limited preview of "Project Gemini," which allows users to perform data analysis from within an Excel environment, will be available this year, Microsoft said Monday.

The company is also preparing to release a private technology preview of "Madison," its upcoming data warehousing platform, which incorporates technology Microsoft gained from its acquisition of DATAllegro last year.

Mobile Security Insider: iOS vs. Android vs. BlackBerry vs. Windows Phone
Recommended
Join the discussion
Be the first to comment on this article. Our Commenting Policies