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…

0 comments, 149 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, 108 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, 275 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, 439 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, 694 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, 139 reads

Posted in Devin Knight on 7 October 2010

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog