Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: June 2009

SSIS - Creating a Deployment Manifest

Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages.  The benefit to using it is the nice user interface that a wizard provides.  The disadvantage of using it is it’s lack of flexibility.  When… Read more

19 comments, 15,668 reads

Posted in Devin Knight on 30 June 2009

Better Know A SSIS Transform – The Sort Transform

This is part 2 of my 29 part series called Better Know A SSIS Transform.  Hopefully you will find the series informative.  I will tell you a little about each transform and follow it up with a demo basic you can do on your own.  Screenshots that go with examples can be… Read more

6 comments, 3,193 reads

Posted in Devin Knight on 24 June 2009

Moron's Guide to SSIS : Episode 2 - Introduction to the Dataflow

Today Pragmatic Works release it’s second comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s boss.  In this video Dustin will teach you how to sabotage your boss by using basic Data Flow components.  Prepare to be insulted!

Watch the video on You Tube and tell… Read more

0 comments, 210 reads

Posted in Devin Knight on 19 June 2009

Enabling Checkpoints in your SSIS Packages

Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten you on what Checkpoints are and why it is beneficial to use them. Also, I will walk you through a basic example package where they have been implemented.

What does… Read more

3 comments, 3,150 reads

Posted in Devin Knight on 18 June 2009

Better Know A SSIS Transform – The Pivot Transform

This is part 1 of my 29 part series called Better Know A SSIS Transform.  Hopefully you will find the series informative.  I will tell you a little about each transform and follow it up with a demo you can do on your own.  Screenshots are included at my regular blog site… Read more

0 comments, 883 reads

Posted in Devin Knight on 15 June 2009

Answers to Advanced SSIS Interview Questions

 

Last week I wrote a set of Advanced SSIS Interview Questions.  Here are the answers I came up for these.  Of course you may have some variation of what I have and I would love to hear how you would answer these.  Feel free to email me how you…

Read more

10 comments, 19,332 reads

Posted in Devin Knight on 12 June 2009

SQL Saturday Pensacola

 I just returned from another great SQL Saturday event today.  Rodney Landrum and Karla Remail put together a great event with an impressive list of speakers. 

I spoke on SSIS Best Practices and Performance Tuning to a great group that was very interactive.  You can download the session slides and… Read more

1 comments, 621 reads

Posted in Devin Knight on 6 June 2009

Moron's Guide to SSIS : Episode 1 - Introduction to the Environment

Today Pragmatic Works release it’s first comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s boss.  The purpose of this video and future videos is to give quick training tips while actually holding your attention with several one liners that make fun of the person that’s… Read more

1 comments, 207 reads

Posted in Devin Knight on 4 June 2009

SQL Saturday 14 Pensacola

 I will be speaking this Saturday at the SQL Saturday in Pensacola.  The topic will be SSIS Best Practices and Performance Tuning.  I’ve prepared some great tips so make sure to see me at 11:30.  Rodney Landrum and Karla Remail have done a great job organizing the event and I look forward… Read more

1 comments, 282 reads

Posted in Devin Knight on 4 June 2009

Advanced SSIS Interview Questions

I wrote a blog about a year ago that gave some tips on basic interview questions that you may run into when interviewing for a SSIS developer job.  Well today upon many request I’m writing an advanced version of these questions.  Sorry for the delay but I’ve been writing a… Read more

0 comments, 1,888 reads

Posted in Devin Knight on 4 June 2009