Chris Adamson’s Blog

Here is the #1 most frequently question that people ask of me: Q: Do I really need surrogate keys? A: You absolutely must have a unique iden...

Shortly before my recent post on unique counts, a reader sent in a related question that takes a slightly different perspective: As fact ta...

A few weeks ago, I touched on some problems you might encounter when trying to store period-to-date measurements in a fact table. Today, ...