By Denny Lee, Ed Campbell Introducing RBS So what is RBS and why would I want to use it in order to help my PowerPivot for SharePoint farm? Well, RBS in this particular case is Remote Blob Store which was introduced as part of one of the SQL Server 2008 Feature Packs. As of this [...]
Archive for February, 2010
Why you may want to use RBS for your #PowerPivot for #SharePoint Farm
Posted in PowerPivot, tagged Design, RBS on February 23, 2010 | 2 Comments »
PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience
Posted in PowerPivot, SharePoint, tagged FAQ on February 17, 2010 | 1 Comment »
For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed. But if you are using a Windows Server OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager. [...]
Granting Excel Services access rights to your #PowerPivot for SharePoint Farm
Posted in PowerPivot, tagged Excel Services on February 10, 2010 | Leave a Comment »
In many of test PowerPivot for SharePoint deployments, the SharePoint Farm Administrator is used for all services including Excel Services during installation or configuration. This is a great and easy way to get yourself up and running fast. But a best practice is to use a different managed account for the application pool that Excel [...]
Pivots, Cube Formulas, Named Sets … Oh my!
Posted in PowerPivot, tagged DAX, Excel, MDX on February 4, 2010 | 5 Comments »
Over the last few days, @PowerPivotPro has been calling me out for diving into the deep end into his world of Excel and getting the proverbial egg on my face (Joker picture not-withstanding). He’s called me out, challenged my geek hood, and sliced / diced my postings (pun intended). I was going to let this [...]

