Archives: November 2010
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.
[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