Microsoft Subnet An independent Microsoft community View more

PowerPivot available for testing with R2

SQL Server

One of the impressive demonstrations at the SQL PASS Summit in Seattle last month was that of PowerPivot for Microsoft Excel, a new integration feature of SQL Server 2008 R2 and Office 2010. The demo would access 100 million rows of data from a cube with interactive sorting within Excel 2010 being performed in a matter of seconds. It was not too long ago that Excel had a 100,000 row limitation. Now that Microsoft has realized that Excel is the front-end tool of choice for our Business Analysts, the upgrade in technology is impressive. The bar has been raised by using column compression technology which takes advantage of repetitive column data in terms of storage savings and performance gains. Using Excel makes sense since our analysts know a lot more about that product than we do and feel very comfortable within it. The only difference is that they are accessing data from Analysis Services rather than a local spreadsheet, perhaps a multi-terabyte cube. The Excel Pivot Table and Chart options are the same as always. If you want to test out this functionality, use the SQL Server 2008 R2 Nov CTP and the following feature pack: http://www.microsoft.com/downloads/details.aspx?FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca&displaylang=en cheers Brian

Insider Tip: 12 easy ways to tune your Wi-Fi network
Join the discussion
Be the first to comment on this article. Our Commenting Policies