Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team.
This week is packed with big announcements: We released Microsoft SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3) with breakthrough innovations that will help our customers to shape their Business Intelligence (BI) future; and we also released Microsoft SQL Server 2008 R2 Service Pack 1 with important improvements of our existing technologies, and PowerPivot for Microsoft Excel 2010 was also updated as a separate download.
Overall, SQL Server 2008 R2 Service Pack 1 consolidates more than 150 quick fixes and improvements. For example, under some circumstances, MDX queries might consume all the physical memory on a computer running Analysis Services 2008 R2 and eventually fail with an “out of memory” error. So, we investigated the circumstances, optimized the affected algorithms, and solved the issue in SP1. In other cases, we simply rephrased error messages to provide better guidance. Particularly, some of our PowerPivot for SharePoint health rule error messages were confusing and misleading. This was also a great opportunity to fix a number of localization issues.
We didn’t add new functionality to PowerPivot for Microsoft Excel 2010, but PowerPivot for SharePoint introduces two new configuration settings that let you determine how long cached data stays in the system. In the new Disk Cache section on the PowerPivot configuration page, you can specify how long an inactive database remains in memory before it is unloaded. You can also limit how long a cached file is kept on disk before it is deleted. Also noteworthy are the performance and scalability improvements that you can gain by using SQL Server 2008 R2 Service Pack 1 together with Microsoft SharePoint Server 2010 Service Pack 1. In fact, some optimizations in SharePoint 2010 SP1 might require you to update PowerPivot in your farm to SP1; especially if you notice that the PowerPivot Management Dashboard is missing workbook activity data or that the workbook snapshot generation in the PowerPivot Gallery stops working after an upgrade to SharePoint 2010 SP1.
For a detailed list of new features and improvements that are included in SQL Server 2008 R2 SP1, review the What's New Section in Release Notes.
PS: Peter Saddow over in the SQL Server Manageability has posted some great information about
How to slipstream SQL Server 2008 R2 and a SQL Server 2008 R2 Service Pack 1 (SP1). Check it out at blogs.msdn.com/.../how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx.
Slipstreaming is a great way to simplify setup tasks and, as Peter points out, helps to avoid any Setup issues that have been fixed in SP1. Creating slipstream media... highly recommended.
What are the version numbers for this PowerPivot for Excel release and the previous one?
This release, Microsoft SQL Server 2008 R2 Service Pack 1 is version number 10.50.2500.0
The previous release was version number 10.50.1747.0
Not sure if this is what you were looking for!
I´m looking for "SQL PowerPivot", is the same that PowerPivot for Excel.
Because I see the Virtual Lab Creating a SQL Server 2012 Tabular BI Semantic Model with PowerPivot, but I don´t have some options whit PowerPivot for Excel.
I belive it´s installed in the server, but I don´t know how to launch it.