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

SSAS Dimension Attribute Discretization Methods

Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is often forgotten.  Basically what discretization does is it can take a dimension attribute and automatically place its members in buckets for you.  For example, if you have a product… Read more

2 comments, 3,718 reads

Posted in Devin Knight on 27 January 2011

SQL Saturday SQLSaturday #62 - Tampa Review

For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event.  As I promised in the Iron Chef session you can download my project files here. 

If you missed this session looks for it at a SQL Saturday near you.  This session is one… Read more

0 comments, 1,245 reads

Posted in Devin Knight on 17 January 2011

SSAS – Hiding Unknown Member

You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that doesn’t actually exist in your data source.  The member that is created is the Unknown member shown below. 

The purpose of the Unknown member is to handling errors that occur… Read more

1 comments, 14,734 reads

Posted in Devin Knight on 10 January 2011

SQLSaturday #62 - Tampa

Hey Folks just a quick reminder that next Saturday January 15th is SQL Saturday 62 in Tampa.  If you haven't been to a SQL Satuday you are missing out.  These have become rather large events now for both learning and networking with other SQL Server professionals.  I will be speaking… Read more

0 comments, 630 reads

Posted in Devin Knight on 6 January 2011