Microsoft Launches SQL Server R2 - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
03:41 PM
Connect Directly

Microsoft Launches SQL Server R2

Fast, in-memory analysis and centralized management are highlights, but will it make BI more accessible to business users?

Few surprises were contained in today's official announcement on Microsoft SQL Server 2008 R2, but the occasion did give the company a chance to stoke interest in SQL Azure cloud services and anticipation of the Parallel Data Warehouse edition of SQL Server expected to launch later this year.

Plans for an upgrade of SQL Server 2008 were first announced in October of 2008, and the community technical preview (beta) became available last November. Thus, customers know what to expect.

Highlights include in-memory analysis capabilities provided by PowerPivot add-ins for Excel and SharePoint, and master data management and complex event processing capabilities aimed at ISVs and developers. The PowerPivot add-ins will enable desktop users to do rapid analysis on up to millions of rows of data with the aid of "slicer" controls used to cut across multiple dimensions. These analyses can then be published for others to see through SharePoint. That combination ensures managed self service, according to Microsoft.

"It's self-service because companies can empower end users to do more analyses on their own in the familiar Microsoft Office environment," said Tom Casey, Microsoft's general manager of business intelligence. "It's managed because IT professionals can easily make data available for reports and analyses while governing who has access to data and monitoring who is using which analyses."

One drawback of the PowerPivot add-ins is that they only work with Excel 2010 and SharePoint 2010, which are currently available in community technical preview releases but won't formally launch until next month. Critics describe PowerPivot for Excel as little more than an in-memory upgrade of the pivot-table capabilities already available in the spreadsheet tool. As such, the add-ins will enable power users to quickly crunch more data, but it won't make developing BI insight any easier or more accessible to spreadsheet novices. For that, developers and Microsoft partners must still create business-process-specific applications and interfaces in Excel.

"There's no doubt PowerPivot is useful and will be successful, but it's not a revolution in BI," said Anthony Deighton, senior vice president of products at QlikTech, a Microsoft rival that introduced in-memory analysis capabilities several years ago. "Microsoft BI still requires application-style development, but many companies just don't like deploying Excel applications."

Microsoft SQL Server R2 also includes several upgrades aimed at streamlining administration. New application and multi-server management capabilities, for example, enable database administrators (DBAs) to centrally manage all instances of applications running on any number of servers. Artifacts such as tables, views, and stored procedures can be grouped, deployed, and managed using unified policies and procedures.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
1 of 2
Comment  | 
Print  | 
More Insights
Top 10 Data and Analytics Trends for 2021
Jessica Davis, Senior Editor, Enterprise Apps,  11/13/2020
Where Cloud Spending Might Grow in 2021 and Post-Pandemic
Joao-Pierre S. Ruth, Senior Writer,  11/19/2020
The Ever-Expanding List of C-Level Technology Positions
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/10/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
Why Chatbots Are So Popular Right Now
In this IT Trend Report, you will learn more about why chatbots are gaining traction within businesses, particularly while a pandemic is impacting the world.
Flash Poll