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: December 2009

Analysis Services Performance Optimization Tips

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I wrote about something I was really interested in learning more about myself.  The result was three articles on performance tuning Analysis Services.  These articles not only explain the benefit to… Read more

2 comments, 823 reads

Posted in Devin Knight on 29 December 2009

Anaylsis Services Partitions and Aggregations PASS Session

For a little more than a year now I've been a part of the PASS BI SIG and have tried to contribute whenever possible.  The SIG is split into several focus groups that meet on all BI topics.  I help in leading the SSIS group.  Today I actually had an…

Read more

0 comments, 133 reads

Posted in Devin Knight on 18 December 2009

Using a SSRS Report to run SQL Agent Jobs part 2

In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by using a report.  In that post I only showed you how to run a single job but hardcoding in the job name.  Someone recently asked if it was possible to…

Read more

2 comments, 911 reads

Posted in Devin Knight on 11 December 2009

Running SSIS 32-bit drivers or tasks on a 64 bit machine

Running SSIS on a 64-bit machine has several caveat that developers need to be aware of.  Tasks like the ActiveX task and Execute DTS 2000 Package Task only work either on a 32-bit machine or by running in 32-bit mode on a 64-bit machine.  This is also the case for… Read more

0 comments, 183 reads

Posted in Devin Knight on 11 December 2009

Running SSIS 32-bit drivers or tasks on a 64 bit machine

This is an answer to a forum question on www.bidn.com

Running SSIS on a 64-bit machine has several caveat that developers need to be aware of.  Tasks like the ActiveX task and Execute DTS 2000 Package Task only work either on a 32-bit machine or by running in 32-bit mode…

Read more

1 comments, 1,504 reads

Posted in Devin Knight on 11 December 2009

Reporting Services Carriage Return

Often when designing a report you may find a need to concatenate values in an expression.  For example, you want a column with full names but your data source has names stored separately for first name and last name.  Easy enough you can write an expression like this:

=Fields!FirstName.Value +… Read more

0 comments, 565 reads

Posted in Devin Knight on 11 December 2009

MDX Utility Belt of Calculations Part 4

This is part four in the series of blog posts that will help in building a library of calculations you can use as a reference in any analysis services cube you build.

You can find the previous posts to this blog series below:

Part 1 – ParallelPeriod

Part 2 –… Read more

5 comments, 1,432 reads

Posted in Devin Knight on 7 December 2009

MDX Utility Belt of Calculations Part 3

This is part three in a series of blog posts that will help you build an arsenal of MDX calculations that you can have ready at the drop of a dime.  The first two posts of this blog series use the ParrallelPeriod and PrevMember functions to return data at… Read more

0 comments, 938 reads

Posted in Devin Knight on 3 December 2009

MDX Utility Belt of Calculations Part 2

This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations.  With this Utility Belt available you can have a template of commonly needed calculations you can use for just about any Analysis Services project. … Read more

2 comments, 942 reads

Posted in Devin Knight on 1 December 2009

MDX Utility Belt of Calculations Part 1

Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube.  That is why I have accumulated what I like to call a Utility Belt of calculation that I can pull out at any moment to solve a problem.  I consider this… Read more

5 comments, 1,501 reads

Posted in Devin Knight on 1 December 2009