It has been a while since I did one of the “A Peek Inside” postings and I thought “what the heck . . . do I have anything better to do while I am visiting with my in-laws during a vacation” . . . I couldn’t think of one so here goes.
PowerPivot has some special [...]
Is now available here: http://msdn.microsoft.com/en-us/library/ff976569.aspx
Recently there was a forum post concerning how PowerPivot parallelizes data refresh . . and I thought this might be an interesting topic for a “Peek Inside” blog posting. The first question is: Why are we doing this? What is the purpose of parallelizing data refresh? Why is this so important? Well . . there [...]
Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster provides an end-to-end view of the PowerPivot Security Architecture in one view. This view includes nearly all of the logical security surface areas and illustrates how these systems interact.
A series of new videos have just been posted that talk about the PowerPivot for SharePoint architecture. This 4-part series is about how user identity is established and flows in different PowerPivot environments.
Part 1: SharePoint User Identity Fundamentals for PowerPivot Administrators = http://www.youtube.com/user/sqlserver#p/u/8/uku4KuzQDIk Part 2: Security context of PowerPivot Connections in [...]
(Update: A complete version of this whitepaper is now available at: http://msdn.microsoft.com/en-us/library/ff628113.aspx – take a look. It is very cool.)
For those interested there was a new PowerPivot component architecture blog that was just posted on the official PowerPivot Team blog, see http://blogs.msdn.com/powerpivot/archive/2010/03/22/powerpivot-component-architecture.aspx. This is an excerpt of an upcoming SQL Server technical white paper called “Microsoft [...]
(This applies to the RTM version of SharePoint and is an extremely common problem that is occurring with all of our RTM servers. I think that it will quickly become one of those things that everyone does each and every time they install a SharePoint server.)
There are two reasons why the “Claims to Windows Token [...]
Recently we been hit with a rash of inquiries around whether folks should install the 32-bit version of the PowerPivot client, or go with the larger capacity 64-bit version. Office 2010 is the first version of Office to offer a native 64-bit option. In previous releases, you had to install the 32-bit version to run [...]