What color are Santa Claus’s Pants?

  Yes, this is a real product you can buy.  And yes, it is VERY disturbing.  It also dances.  Yeah. A bit off topic today.  Fridays are like that sometimes.  Let’s call this Friday Brain Food. SQLRockstar’s Masterpiece SQLRockstar, aka Tom LaRock,  has written something awesome on his blog.  It deals with interview questions and hiring and is one of the most insightful things I’ve read in a long time.  It’s a short post – go read it now and…

Read the Rest

Distinct Count in PowerPivot v2 – MUCH Faster

A quick update, as tonight I managed to sit down and experiment a bit with the V2 Beta for the first time in many days. (OK, actually, I am standing up…  because I have a fantastic new treadmill desk and have walked nearly 8 miles today while working, but that’s a topic for another post). I was working with one of our HostedPowerPivot clients today who was observing slower-than-expected slicer click performance in one of their reports.  And after some…

Read the Rest

Couldn’t Resist… Parameterized PowerPivot Report!

In the intro to David’s guest post below I mentioned some new applications we are building.  Check out a PowerPivot report where, in the browser, you can type in a SKU number and get a full dashboard for just that product! Click for Larger Version Much respect to our resident Data Junkie Monkey, aka DJ Monkey, for pulling this together.

Read the Rest

Guest Post: TOPN in PowerPivot V2

Well folks I haven’t had much time to play with the V2 Beta (aka CTP3) yet.  A lot going on over the past week: Authoring a brand new suite of models and reports for our Duane Reade DR-Direct solution A nasty crashing bug in PowerPivot for SharePoint that we’ve now learned to catch and repair I submitted a PowerPivot article to CIMA Insight magazine (for August) Running refresh tests with PowerPivot servers in Chicago pulling data from SQL in Dallas…

Read the Rest

PowerPivot V2 CTP3!

“Tell ya what Mom…  just lock me in here tonight.  I will be fine.” A lot of you are already on the scent, but just in case… WAHOOOO! CTP3 = “Public Beta” What the heck is a CTP, you ask?  Well it’s a “Community Technology Preview.”  You know…  what we used to call a Beta.  Calling it a CTP is a much more grown-up approach.  But it’s silly IMO.  A Beta release of PowerPivot V2 is EXCITING!  “Beta” was, and…

Read the Rest