SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Archives: July 2011

PowerPivot – Creating Hierarchies

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

7 comments, 4,826 reads

Posted in Devin Knight on 31 July 2011

Modified Insert Unknown Row to Dimension Table

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

0 comments, 2,785 reads

Posted in Devin Knight on 29 July 2011

Tallahassee User Group meeting August 9th

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

0 comments, 763 reads

Posted in Devin Knight on 21 July 2011

PowerPivot - Diagram View

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

2 comments, 2,634 reads

Posted in Devin Knight on 21 July 2011

PowerPivot - Measure Grid

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

0 comments, 2,497 reads

Posted in Devin Knight on 20 July 2011

SQL Server Denali Installation Change

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

0 comments, 1,391 reads

Posted in Devin Knight on 20 July 2011