Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies are useful because it allows a single click for a user to bring in all the fields that exist in a natural table hierarchy.  Normally the user would have to… Read more

A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension.  This is a great script and i've used it dozens of time, but this week I made a few modifications to it that I thought I would share.

First… Read more

For those of you in the Tallahassee, FL area on August 9th at 6:00 pm I will be speaking virtually for the Tallahassee PASS user group.  Several of the groups leaders attended SQL Saturday in Jacksonville this year and after speaking with them it sounds like they have a fanatics… Read more

The new “Denali” PowerPivot has a lot of fanatic new additions that I’ve really been looking forward to.  Many of my biggest complaints from the first version of the product have been addressed.  One of these complaints was the lack of a visual representation of object relationships.  You had to… Read more

There are a lot of fantastic new features in the latest CTP 3 release of PowerPivot, which you can download here.  This is a huge change for PowerPivot and really shows how the product is maturing into become a tool that can solve a variety of problems that it… Read more

Tonight I took my first crack at getting SQL Server Denali up and running on my machine.  From what I had read so far there are no longer issue with installing a side by side instance of Denali with an existing SQL Server install so I went that route.  The… Read more