Chris Adamson’s Blog

Best practices in dimensional modeling forbid the use of NULL.  In this post, you'll learn why. In any relational database, allowing N...

People often suggest to me that a dimensional model cannot handle certain situations. These situations, the assertion holds, require falling...

A reader asks how name/value pairs are best translated into a dimension design. I was wondering if you have ever had to setup a data wareh...