The fine folks at Varigence were kind enough to invite me to come and spend a couple of days with them at their headquarters in Greenville, NC. I’m excited to discuss Biml strategy with them, and how to best leverage and extend my BimlScript frameworks. To be honest, I can’t wait to spend some quality time with them to compare notes and pick up some new ideas.
I’m also going to present something new tonight for the SQL Server Innovators Guild (SSIG).
A CRUD-dy Alternative to Slowly Changing Dimension Processing
Slowly Changing Dimensions (SCD) are the foundation of Data Warehousing. Many of us use T-SQL Merge to process SCDs because the pattern is well known and it performs reasonably well. However, many experts in the SQL Server Community recommend that we stop using it, due to many outstanding bugs, but have not recommended a suitable T-SQL alternative.
In this session, I’ll show you how I use standard CRUD, mostly Inserts and Updates, to process Slowly Changing Dimensions. My current design pattern yields high performance, great flexibility, and easily maintainable code. As an added bonus, you’ll leave this presentation with the design pattern and code samples that you can quickly put to work in your environments.
Wednesday night I’m flying back home to Michigan for a few days to spend time with friends and family. It’s been too long, and I need to recharge my batteries.