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

SSIS Denali Annotations

I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.  In previous posts I wrote about Resolve References and Data Flow Grouping. 

Today I am writing about another quick tidbit.  Annotations are a feature that has been available in previous… Read more

1 comments, 649 reads

Posted in Devin Knight on 24 November 2010

SSIS Denali Data Flow Grouping

There have been several usability features that have been added to SSIS in the latest CTP.  One of these features is Grouping in the Data Flow.  This is a feature that exists in current versions of SSIS but only in the Control Flow. 

It will work the same way it… Read more

0 comments, 824 reads

Posted in Devin Knight on 22 November 2010

SSIS Denali Resolve References

One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z) is the new resolve reference functionality that was brought into the product from the Parallel Data Warehousing team.  Resolve references is solving the problem that occurred when you created a… Read more

1 comments, 1,358 reads

Posted in Devin Knight on 15 November 2010

SQL Rally Precon Vote Results

The votes have all been tabulated and during PASS this week the top pre conference seminars were announced for SQL Rally.  Thankfully our Business Intelligence Workshop session won!  I want to thank you all for taking the time to vote for Patrick, Adam, Mike, and myself.  I promise we… Read more

0 comments, 498 reads

Posted in Devin Knight on 12 November 2010

SQL Server 2011 (Denali) no DTS support

The end has come!  We've been told for several years the vNext of SQL Server will no longer support DTS and it appear that that time has come.  Taking a look at the CTP of SQL Server Denali one of the first things I noticed is that you no longer… Read more

25 comments, 3,491 reads

Posted in Devin Knight on 11 November 2010

Date Dimension Using Computed Columns

Picked up this nice script from a client last week.  Use this script below to create a Date Dimension for a data warehouse that is based off of computed columns. The only column that needs to be populated is the CalendarDate column.

TABLE [DimDate](
[DateKey] [int] IDENTITY(
Read more

0 comments, 1,113 reads

Posted in Devin Knight on 8 November 2010

MDX - Color Formatting on All Measures at Once

In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services measures you create.  Recently I found a way to apply this same color formatting to all your measures.  Why would you want this?  Well let's say you want to all… Read more

0 comments, 2,816 reads

Posted in Devin Knight on 4 November 2010