Ramblings about missing time … and #PowerPivot sneak peek!

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… aaaaaaahhhhhh!!

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?!



  1. Full props to you for choosing the tourney over the pad.

    1. Thanks Seth – ultimate definitely makes more sense, eh?!

  2. Smooth as apple design may be — the pad doesn’t look very aerodynamic 😛

    But more seriously- you chose experience over stuff and that’s rarely a decision to regret. Good spirit sports combined with international travel how could you lose on that?

    Did you go with a whole team from WA?

    I’d love to get out there myself (have a nuimber of Korean friends I’d love to visit some day). But I’m guessing they don’t field a pick-up team and I don’t know who the heck else I’d play with…

  3. Actually, there are three pools and it may be possible to pick up if you get involved early enough. I would just ping the organizers of KUPA (Korean Ultimate Players Association) to see if any teams need extra players. I ended up joining the Taipei team b/c I played with them before so no problem. Right now, Jeju looks like its strictly an Asian tourney right now – but its getting larger every year. And with plenty of ex-pats going back and forth between Korea and the US – it’s just a matter of time, eh?!

    Disc up, eh?!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s