The Data Vault vs. Kimball 2012-06-26 Data Modeling No Comments Data Warehouse, Dimensional Models, Rant
Why You Need to Stop Worrying about UPDATE Statements 2012-04-27 Data Modeling No Comments Data Warehouse, FusionIO, Keys, Patterns, Performance, Relational, SQL Server
When Database Statistics are not Enough – Search Patterns 2012-02-21 Data Modeling Databases No Comments Histogram, I/O, Patterns, SQL Server, Statistics
Don’t Become a One trick Architect 2011-12-08 Data Modeling No Comments Architecture, Cursors, Data Warehouse, ETL, HADOOP, Hardware, OLTP, XML
Why Surrogate Keys are not Good Keys 2011-10-22 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Relational
The Big Picture – EDW/DW architecture 2011-08-30 Data Modeling No Comments Architecture, BI, Data Warehouse, ETL, HADOOP, Staging
Physically Placing the Maps in the architecture 2011-08-19 Data Modeling No 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 No 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 No Comments Data Warehouse, ETL, Keys, Maps, Master Data, Staging