Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog.
But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee)
But I do have a good excuse! Really!
Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂
RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling this like a champ (he’s got some great postings on his site: PowerPivotGeek.com, eh?!). His and my postings are re-posted on PowerPivotTwins.com – the PowerPivotTwins in one place – yay!
Some great ones that you really need to review include:
- A Peek Inside: Allocation. What is it? Why is it important?: This is a really important post because it talks about why you should use the health-based load balancing allocation method. If you plan to have a lot of users on your PowerPivot for SharePoint environment involving multiple servers – read this posting!
- PowerPivot Component Architecture: As noted in the blog post, this is an excerpt from “Microsoft SQL Server PowerPivot Planning and Deployment” whitepaper will be coming out shortly. Once its published, we’ll point to it from this blog post, SQLCAT.com, PowerPivot blog, etc. But if you want to understand all of the components within PowerPivot – from Excel Services to the OLE DB Provider for Analysis Services to PowerPivot System Service – here’s the sneak peek, eh?!
- Help: c2wts has fallen and it cannot get up: As noted in the above PowerPivot Component architecture, in order to facilitate communication from PowerPivot System Service to the Analysis Services Engine in VertiPaq mode, we need the Claims to Windows Token Service up and running. Sometimes c2wts starts up slowly (if its not running, then you will get an Excel Services delegation error); this great post from Dave provides some tips on how to get c2wts working faster.
Writing, Writing, … and Writing
Fair enough, this is just a blatant self promotion here, but I’ve been working nights and weekends with my Analysis Services compatriots Siva Harinath and Ron Pihlgren on our upcoming book: Professional Business Intelligence with PowerPivot for Microsoft Office 2010
Why not pre-order this book and make my publisher happy :). But seriously, we hope this book provides you a great end-to-end picture of PowerPivot, eh?!
Can I blame it on the Apple iPad?
Yes, just like the NY Times, I’ve been drooling over this device over the last month or so. Perhaps my mind was entranced over the large screen and just how dang cool it looks. Alas, as amazing as it is – it couldn’t hold me over for a month – geez! Actually, if you follow me via Twitter or Facebook at all, you’ll probably notice the tweet:
Don’t say I don’t love the game of ultimate frisbee, I chose going to gnarly nines tourney in JeJu (South Korea) over an Apple iPad!
In reality, that’s what’s been driving me nuts – the fact that I had to choose between an ultimate tournament or an Apple iPad…and amazingly, I chose the former.
And here I am in all my (fat) glory hucking a disc – because dang it, I love the game of ultimate. Enough that the Gnarly Nines tourney in Jeju is holding sway over me even though I’m old, fat, cannot run, frankly untalented….yeah, that just about covers it!
Nah…it was TechReady 10!
Ahh…but for all of you that follow me on FourSquare, perhaps its a different story. From there, you’ll realize that one of the Microsoft employee conferences we have each year is called TechReady (similar to TechEd – which is New Orleans in June this year) except for employees only and always in Seattle (whew, less flying).
And with all of the Analysis Service AND PowerPivot stuff that we were talking about – that just frankly took the cake and wore me out.
Well, that’s the sneak peek in store. If you are fans of the SharePoint Technical diagrams (poster diagrams providing excellent view of SharePoint), well over the next few months – we will be releasing PowerPivot Technical diagrams as well! I figured I’d jump the punch because there were some postings and questions fielded after TechReady, eh?!
To infinity…and beyond!
So things are starting to get more normal for me and I’ll start blogging again with all sorts of cool PowerPivot and Analysis Services stuff, eh?! And as soon as the first of the many PowerPivot Technical Diagrams is ready for your review, we’ll publish them and blog / tweet crazy, eh?!