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

Auditing Report Executions with Free Source Code

Have you been looking for a way to measure report performance?  Want to know who accesses your reports most frequently?  Well there are some free reports on http://msftrsprodsamples.codeplex.com/ that you may already have downloaded and don’t realize it that contains this information. 

When you download the AdventureWorks…

Read more

2 comments, 717 reads

Posted in Devin Knight on 30 March 2010

Using SSAS MDX Calculation Color Expressions

Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also have another little feature that adds just a little more wow when your end users browse the cube. 

By building a color expression on a calculation you can…

Read more

1 comments, 2,274 reads

Posted in Devin Knight on 17 March 2010

Solving All Versus (Select All) SSRS End User Confusion

When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters.  Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting… Read more

0 comments, 191 reads

Posted in Devin Knight on 12 March 2010

Solving All Versus (Select All) SSRS End User Confusion

 

When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters.  Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option…

Read more

4 comments, 2,068 reads

Posted in Devin Knight on 12 March 2010

Using Excel 2007 in SSIS 2005

Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade.  This results in the majority of companies still running previous versions of SQL Server (2005, 2000, and even earlier).  Many times as the developer you are forced to work…

Read more

0 comments, 410 reads

Posted in Devin Knight on 2 March 2010

Using Database Transactions across multiple SSIS Tasks

 

If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed.  For example, if you have a transaction running on an entire package some tasks may not rollback on a failure.  A file system task is one of…

Read more

5 comments, 1,256 reads

Posted in Devin Knight on 2 March 2010