Very cool podcast with John Hancock concerning data feeds – http://itc.conversationsnetwork.org/shows/detail4453.html
Abstract: PowerPivot, a new add-in for Excel, can absorb and analyze vast quantities of data. And it can ingest that data from sources that support that Atom-based OData protocol. John Hancock, who led the charge to add support for data feeds to PowerPivot, tells host [...]
Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:
The result set must have a name associated with each column. If you are not returning the column [...]
OK, here is our first ‘bug’. As part of the PowerPivot Management Dashboard, we ship a .odc file that is used to point to the PowerPivot dashboard data workbook (the data you see in the dashboard reports). You can click on the .odc file and Excel desktop will popup pointing to the dashboard data. Unfortunately [...]
Now that RTM has been released, I have started to update the installation pages in the “Server Installation” section. If you are interested, take a look at: http://powerpivotgeek.com/server-installation/single-server-install-rtm/ It has been updated for RTM w/ some new screen shots. You will see the only real difference is that all of the required hotfixes and other [...]
OK. You have seen the announcements. You have heard the trumpets sound.
SQL Server 2008 R2 has “released to manufacturing” (RTM’ed) and will be available soon!
EXCELLENT! WOW! OUTSTANDING!
So what does it mean to this blog. First and most importantly, I am going to be reposting all of the installation guides with RTM bits and screen shots. [...]
SharePoint 2010 has a new ‘claims-based’ authentication system that allows you to use federated identities with SharePoint. And there are certainly some customers that are excited to start playing around with this capability. That is neat and cool and all . . . but that isn’t the major reason why folks should be getting excited [...]
(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 [...]
As more and more folks start to get into PowerPivot and SharePoint, there is a need to programmatically write entries into the ULS. Since all of PowerPivot and all of SharePoint share this common logging infrastructure, why not also include log entries from your own processes. Here is some sample code for doing that:
First via [...]
And update (April 7, 2010 14:19 PST) – fix has been released!
For all of you that are running a combined all-in-1 system, i.e. domain controller, SharePoint and all of PowerPivot (desktop + server), you will notice that if you are trying to debug with non-administrator accounts that you can no longer remote desktop on to your machine. This is because by default only administrators are allowed [...]