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 2008

Review of Seadragon: Microsoft’s iPhone application

So I’ve spent the last couple of weeks playing around with the Seadragon application and have come to some conclusions.

Usefullness – 1 out of 5

Seadragon is a glorafied picture viewer.  Had this not been a Microsoft app I would have never downloaded it to test. 

Performance– 4 out… Read more

0 comments, 1,445 reads

Posted in Devin Knight on 29 December 2008

SSIS – Avoid OLE DB Command

I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS packages.  I wanted to define to what extent just one simple change could make to a package. 

So in this test I decided to show the difference in using a… Read more

8 comments, 14,140 reads

Posted in Devin Knight on 29 December 2008

Microsoft’s First iPhone Application

Can you believe it?  Microsoft has just released an iPhone application for the first time and I doubt it will be the last one.  It is really hard to believe knowing that Microsoft has it’s own platform for mobile users.  I can tell you without a doubt after using both… Read more

0 comments, 2,035 reads

Posted in Devin Knight on 17 December 2008

SQL Quiz Part 2

I was recently tagged by Tim Mitchell to give a response to Chris Shaw’s SQL Quiz Part 2 so here it goes.  It looks like most people who have answered have pretty long responses but I think I’m going to keep it short and sweet.

The Questions for this quiz…… Read more

2 comments, 774 reads

Posted in Devin Knight on 15 December 2008

SSIS - Fast Parse

I had another chance last week to answer an email follow up question from the session Brian and I gave at PASS.  This made for a great blog opportunity so I thought I would write about using Fast Parse in SSIS.  Hopefully I can explain it even more basic then… Read more

0 comments, 6,988 reads

Posted in Devin Knight on 15 December 2008

Using Result Set as Variable in Stored Procedure

I’ve been asked several times lately from non-SQL developers that are sometimes required to do some quick SQL work how to use the result set of a query as a variable in a stored procedure. My first thought was I’ll just send them a link to a website that can… Read more

3 comments, 2,803 reads

Posted in Devin Knight on 8 December 2008

My Thoughts: Report Builder 2.0

General Thoughts

One of my brother’s favorite lines to use in presentations says it best, “If Microsoft had 10 dollars to spend on BI in 2008 then they spend 8 of it on Reporting Services.”  It’s a good description and if you ask me it was money well spent.  When… Read more

0 comments, 942 reads

Posted in Devin Knight on 2 December 2008