SELECT INTO – Moving Data From A to B 2014-05-01 SQL Server Archive No Comments Data Warehouse, ETL, Staging
The Information Staircase 2012-07-01 Data Modeling No Comments Abstraction, Architecture, BI, Data Warehouse, ETL, Staging
Running Many Batch Statements in Parallel 2012-01-08 SQL Server Archive No Comments Async, ETL, Parallelism, SQL, SQL Server, Threading
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