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

SQL Rally Cast Your Vote!

Pre Conference seminar voting is up now.  Go make it happen!  Here's the description of our session:

Title:

 

Business Intelligence Workshop

Speaker: Patrick LeBlanc, Devin Knight, Mike Davis, & Adam Jorgensen
 Level: Intermediate
Abstract: In this full-day workshop, you'll learn from the author team of Mike Davis, Adam Jorgensen, Devin…

Read more

0 comments, 252 reads

Posted in Devin Knight on 26 October 2010

SQL Rally Precon - We Need Your Vote!

Okay SQL Community, I need your help!  Patrick Leblanc, Adam Jorgensen, Mike Davis and myself have submitted a precon for the exciting new event SQL Rally, which will be from May 11 - 13 in Orlando, FL.  This event new event is designed to bridge the gap… Read more

0 comments, 207 reads

Posted in Devin Knight on 23 October 2010

SQL Lunch #36 - Overview of Common DAX Expressions

Tuesday at 12:30 pm I will be presenting for SQL Lunch giving you an overview of some common DAX Expressions in PowerPivot.  PowerPivot is still a very new technology and in this session you will get familiar with how you can create calculated columns and calculated measures using DAX. 

Speaker: Read more

0 comments, 399 reads

Posted in Devin Knight on 22 October 2010

Issues With Calculating Current Age Using DateDiff (Rounding?)

Recently I inherited a set of SSIS packages that did a pretty simple calculation for age.  It used the following expression, which could just as easily be in T-SQL, to return back the current age of a person:

DATEDIFF("YYYY", BirthDate, GETDATE())

Seems to make sense right?  It sounds like it… Read more

0 comments, 645 reads

Posted in Devin Knight on 9 October 2010

SSRS - Join Function

Often when designing a Reporting Services with parameters you may be required to display those parameter values on your report.  This is beneficial when you have a lot of values for one parameter or maybe you just want to print the report and need to know how the report is… Read more

1 comments, 1,149 reads

Posted in Devin Knight on 8 October 2010

Speaking at SQL Saturday #49 Orlando

To all who live within a drive (or even a flight) to Orlando I really recommend you attend SQL Saturday Orlando next Saturday October 16th.  I and many other great speakers will be in attendance to give you great information on relevant SQL Server topics.  I will be giving a… Read more

0 comments, 218 reads

Posted in Devin Knight on 7 October 2010