Category: Data Solutions

Late Arriving Dimensions

When building a dimensional model it is critical that facts have accurate foreign keys pointing back to related dimensions.  However, there are some situations where

Quick Review–ACID

One of the foundation concepts that all database workers should keep in the back (or maybe front) of their mind is ACID.  This small and

Accumulated Snapshot Fact Table

When creating a model to describe a process that has a clear beginning, end, and phases in between, the accumulated snapshot fact table may be

SSIS Package Execution Precedence

SQL Server Integration Services offers developers a powerful toolset capable of performing a wide range of integration tasks.  Data mart developers will typically design numerous

Schema? Prefix? Both or None?

When building SQL Server data warehouses should user-defined schemas be used?  Should tables and views be prefixed?  Or, maybe we should do both.  After talking