Getting ready for enterprise SSAS and PowerPivot at PASS with SQLCAT!

If you’re online this week, and admittedly the last few weeks I have been extremely dormant, you may know that next week is the 2010 SQL Server PASS Summit!   It’s one of the most important SQL Server conferences and my team, SQLCAT,  will be out in force.  Heck, we’ll be in our green SQLCAT shirts so we’ll be noticeable from across the Washington State Convention Center.   Just in case you do not already know, SQLCAT is a SQL Server product group team that works with some of the largest implementations of SQL Server.  By doing this, we help improve…

Rate this:

Can I access PowerPivot via a data access API?

I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store?   I figured that a lot of people will eventually ask this question (heck, that’s what I had asked when I had first heard about PowerPivot).  The answer as of 2010 is: Right now, there is no supported way to access the data store within Excel as all PowerPivot for Excel APIs are private.  Saying this, the data store backup is stored within Excel itself as per the posting For Excel PowerPivot, the database is IN…

Rate this:

PowerPivot for SharePoint: Existing Farm Installation

So the fate… of the entire human race depends upon my wild guess      — Doctor Gaius Baltar (Battlestar Galactica)     Actually, the quote that I really wanted to say was “So the fate… of the entire PowerPivot deployment depends upon my wild a** guess?!  WTF!!!”   Yet, this is not the time for us to go quietly in the night!  Do not go gentle into that good night! (Dylan Thomas)   Okay, I’ll stop now. But seriously, PowerPivot for SharePoint for an existing farm installation can be complex and mind numbing at times – especially with the 20…

Rate this:

PowerPivot for SharePoint: Single Server Installation

A long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! So hats off to the Analysis Services product team for building an easier PowerPivot for SharePoint installation by providing us with the “New Server” installation choice.    Yet, even with the easier installation steps, it is important to make sure you do the steps in the right order and have the correct prerequisites installed to make it a smooth installation experience. During the CTP (Community Technology Preview) process, a number of us had got…

Rate this:

Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an Atom feed) and its data can be imported directly into a PowerPivot for Excel workbook.  To get this thing to work, one of the key things that I remind people regularly is to make sure you install  ADO.NET Data Services Update for .NET Framework 3.5 SP1. ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008 ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows…

Rate this:

PowerPivot Technical Diagram: PowerPivot Security Architecture

Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN.  To get access to the PDF, XPS, and/or VSD files, please click through to: http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx   Enjoy!

Rate this:

At TechReady and want a chance to get a PowerPivot Technical Diagram AND win a PowerPivot book?

Are you coming to TechReady and interested in getting yourself a PowerPivot Technical Diagram: PowerPivot Client/Server Architecture? Well, make sure to come to Dave Wickert and my session for a chance to get a printed copy of this awesome diagram!: BIN403: PowerPivot for SharePoint Power Hour…so powerful its 75min 7/30 10:30-11:45am, Sheraton Metro B You’ll also get a chance to win one of two copies of the Professional Microsoft PowerPivot for Excel and SharePoint book as well! Enjoy and see ya there!

Rate this: