Exploring Hash Functions in SQL Server 2011-11-06 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Hashing, Keys, Performance, Scale, SQL Server
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
An Overview of Source Key Pathologies 2011-07-30 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Keys, Master Data, Staging
The Ascending Key Problem in Fact Tables –Part two: Stat Job! 2011-07-07 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Histogram, Predictability, SQL, SQL Server, Statistics
The Ascending Key Problem in Fact Tables– Part one: Pain! 2011-07-01 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Predictability, Query Plans, SQL Server, Statistics
Good keys, what are they like? 2011-05-13 Data Modeling No Comments Data Warehouse, Keys, OLTP, Relational