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
7 reads
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
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...
2011-03-09
1,035 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
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-03-03
2,559 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,362 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
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
What Strategies Drive Success Behind the Best Medical Ads?
Now and then, I come across a medical ad that feels different. It does...
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...
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