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: December 2010

SSAS Understanding Multiple Security Roles

In a previous article I showed how you can create dynamic security in SSAS.  This is a great way to make all security table based using Active Directory accounts associated with the items that the user is allowed to see. 

If you decide that your security model is pretty basic… Read more

0 comments, 2,930 reads

Posted in Devin Knight on 28 December 2010

SSIS to SQL Server Data Type Translations

I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS data types.  At first glance they seem to be nothing like SQL Server data types you love and know.  That's why I've provided below a conversion chart of SSIS data… Read more

4 comments, 46,362 reads

Posted in Devin Knight on 22 December 2010

Work With Me at Pragmatic Works

Recently Adam Jorgenson wrote a blog post titled Come be your best at Pragmatic Works, which described the work environment at our company and how we have many positions are available now at varying experience levels.  One thing that I’ve noticed when talking to people about applying with us… Read more

3 comments, 967 reads

Posted in Devin Knight on 14 December 2010

SSIS Denali Source and Destination Assistants

In several previous posts I have described some of the usability changes that will come with the next release of SSIS.


Data Flow Grouping

Resolve Reference

Today I’m going to introduce you to the Source and Destination Assistants that has been added to the Data Flow.  The idea behind… Read more

0 comments, 1,459 reads

Posted in Devin Knight on 13 December 2010