More Changes for the Dimension Merge SCD?
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
5 reads
Todd McDermid's Blog
More Changes for the Dimension Merge SCD?
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results...
2011-03-14
940 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
3 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
4 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over...
2011-03-09
1,035 reads
Changes to the SSIS Slowly Changing Dimension Component
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
2011-02-25
3,257 reads
How To: Load Dimension Tables with Integration Services - Introduction
When I first started down the business intelligence and data warehousing road, I needed to learn the foundations of dimensional...
2011-02-16
1,335 reads
Performing a Cross Join (Cartesian Product) in SSIS
There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS. One of...
2010-09-28
4,361 reads
Parallelism in SSIS - Multiple Lookups
This question just came up in the forums, and it highlights how difficult it can be to try to optimize...
2010-09-06
2,146 reads
Convert Several Columns in SSIS With Fewer Clicks and Confusion
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
699 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers