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

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

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

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

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

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.


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

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