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

SQL Saturday #74 Jacksonville

For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already know about these events but just to remind you it is a totally FREE all day event that brings top speakers to you.

I hope everyone already realizes this, but… Read more

0 comments, 1,482 reads

Posted in Devin Knight on 30 March 2011

SSAS - Measures or Attributes in Multiple Display Folders

I had a client recently show me a neat little tip that I thought I would share.  In the cube he was designing he had the need for measures to show under multiple display folders.  For example, he had a Sales Amount measure and he wanted it to be in… Read more

1 comments, 1,257 reads

Posted in Devin Knight on 22 March 2011

Passing Values into an SSIS Package at Runtime from Outside the Package

SSIS provide several methods for passing values into your packages at runtime.  The benefit of doing so allows you to change the results of the package without having to even open the package in the development environment (BIDS). 

The typical way of doing this is to create variables inside your… Read more

8 comments, 28,344 reads

Posted in Devin Knight on 14 March 2011

SSAS – Changing the Dimension ALL Member Name

All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.  For example, let’s say you have a product dimension with an attribute for the product name.  This attribute will be given an All member that represents every product.  The All member has… Read more

0 comments, 2,120 reads

Posted in Devin Knight on 7 March 2011