The Data Vault vs. Kimball 2012-06-26 Data Modeling 6 Comments Data Warehouse, Dimensional Models, Rant
Why You Need to Stop Worrying about UPDATE Statements 2012-04-27 Data Modeling 5 Comments Data Warehouse, FusionIO, Keys, Patterns, Performance, Relational, SQL Server
When Database Statistics are not Enough – Search Patterns 2012-02-21 Data Modeling Databases 4 Comments Histogram, I/O, Patterns, SQL Server, Statistics
Don’t Become a One trick Architect 2011-12-08 Data Modeling 12 Comments Architecture, Cursors, Data Warehouse, ETL, HADOOP, Hardware, OLTP, XML
Why Surrogate Keys are not Good Keys 2011-10-22 Data Modeling 35 Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Relational
The Big Picture – EDW/DW architecture 2011-08-30 Data Modeling 36 Comments Architecture, BI, Data Warehouse, ETL, HADOOP, Staging
Physically Placing the Maps in the architecture 2011-08-19 Data Modeling 2 Comments Architecture, Data Warehouse, ETL, Keys, Maps, Master Data, Staging
Transforming Source Keys to Real Keys – Part 2: Using Maps To Fix Key Problems 2011-08-15 Data Modeling 11 Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Maps, Master Data, Staging, Type2
Transforming Source Keys to Real Keys – Part 1: Introducing Map tables 2011-08-04 Data Modeling 18 Comments Data Warehouse, ETL, Keys, Maps, Master Data, Staging