SQL Server version table

** Updated on 10/13/2014 with latest SQL Server 2014 release information ** To ensure my clients and I are running on the proper version of SQL Server I have created a reference table that contains all the SQL Server versions since 7.0. The script to create the table is too large to include here, but I have added an option …

Type 2 SCD with SQL Merge

I was going through some notes I had from previous projects and came across a sample script for created a Type 2 Slow Changing Dimension (SCD) in a database or data warehouse. A Type 2 SCD is one where new records are added, but old ones are marked as archived and then a new row with the change is inserted. …

WILTW – Mind the details

This past week has been crazy with getting ready for family arriving and then all of us heading down to Miami for SQL Cruise! I did not make good notes of this week’s lessons, but here are main highlights of what I recall: