Fast, in-memory analysis and centralized management are highlights, but will it make BI more accessible to business users
Few surprises were contained in the recent 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.
Source:
http://www.informationweek.in/Software/10-04-22/Microsoft_launches_SQL_Server_R2.aspx
Free Iphone, Custom Website Design, Professional Web Design
Few surprises were contained in the recent 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.
Source:
http://www.informationweek.in/Software/10-04-22/Microsoft_launches_SQL_Server_R2.aspx
Free Iphone, Custom Website Design, Professional Web Design
No comments:
Post a Comment