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 2009


Yesterday I participated in my first BI SIG live meeting.  This special interest group is led by Amy Lewis who did a great job yesterday setting the agenda for the new year. 

I think she had a great idea of starting BI SIG "Focus Groups”, which will focus on the… Read more

0 comments, 664 reads

Posted in Devin Knight on 15 January 2009

Thanks to PASS - Free Laptop

It seems like the benefits of being involved in PASS just never stopped.  If you didn’t see the PASS newsletter sent out yesterday or the PASS website then you don’t know I won a laptop for creating a PASSPort profile

It all happened rather fast.  I got an email… Read more

3 comments, 569 reads

Posted in Devin Knight on 15 January 2009

Windows 7 Beta Delayed

Looks like the Windows 7 beta download has been delayed while Microsoft adds additional infrastructure support.  A little disappointing but I guess it's best to make sure everyone has a good experience with this new version of Windows from the beginning.  I'll provide an update when I see it's back and… Read more

2 comments, 619 reads

Posted in Devin Knight on 9 January 2009

Windows 7 Beta Release Friday

Tomorrow Microsoft will make Windows 7 beta available for download.  I’m a little skeptical but I think just about anyone who used Vista would be.  To be honestly I haven’t had nearly as many challenges with Vista that many people claim to have especially early in it’s release.  However, I… Read more

2 comments, 658 reads

Posted in Devin Knight on 8 January 2009

SSIS – CHECKSUM Transformation

CHECKSUM is a TSQL function that computes a hash value over a list of arguments.  The great thing about creating a hash value for a table is that it gives you a unique value to represent each row. 

When would you use the CHECKSUM Function?

An example of using a… Read more

14 comments, 19,401 reads

Posted in Devin Knight on 5 January 2009