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: April 2011

SSAS - Creating and Using a Writeback Measure Group

Imagine you have spent the last 9 months developing a sales Data Warehouse and an Analysis Services cube.  Your end users love what you have built for them so far but it’s never good enough right?  You have a new requirement to allow your users to enter in projected or… Read more

2 comments, 4,260 reads

Posted in Devin Knight on 25 April 2011

SSAS – Using Dimension OrderBy AttributeKey

Often when building dimensions there is a need to order you dimension attributes by something other than the NameColumn or KeyColumn properties.  An example of this may be an accounting structure that is preferred to be viewed in a certain order.  The data doesn’t represent that order well so you… Read more

0 comments, 4,125 reads

Posted in Devin Knight on 19 April 2011

SQL Rally Schedule


Thursday, May 12





8:30 - 9:30

SQL Server Parallel Data Warehouse - Under the Hood

Brian Mitchell

The Dirty Dozen: PowerShell Scripts for the Busy DBA

Aaron Nelson

A data-logic approach to EF4

Mattias Lind

Iceberg, Dead Ahead! - Lessons from real life…

Read more

0 comments, 1,107 reads

Posted in Devin Knight on 5 April 2011