Improving Analysis Services Performance and Scalability with SQL Server 2016 Service Pack 1

SQL Server 2016 Analysis Services delivered numerous performance improvements over previous releases, such as better modeling performance thanks to the new 1200 compatibility level for tabular databases, better processing performance for tables with multiple partitions thanks to parallel partition processing, and better query performance thanks to additional DAX functions that help to optimize the client/server… Read more

About the Relativity of Large Data Volumes

Some conversations in our team are really priceless. The other day, while working on an article about Analyzing Performance Data in PowerPivot, I was bragging to Ashvini about the fact that I was able to import a 55 GB database with more than 200 million rows of data into a 1 GB PowerPivot workbook, as… Read more

Released: Microsoft SQL Server 2008 R2 Service Pack 1

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… Read more

Released: Service Pack 1 for Microsoft SharePoint Server 2010

 Today is a great day for us PowerPivoteers because Service Pack 1 for Microsoft SharePoint Server 2010 has been released. You can download it from our new and fantastic Microsoft.com Download Center at http://www.microsoft.com/download/en/details.aspx?id=26623. Why is this SharePoint Service Pack so important for PowerPivot? Among other things, it lowers the number of query requests Excel… Read more