SELECT INTO – Moving Data From A to B 2014-05-01 SQL Server Archive 6 Comments Data Warehouse, ETL, Staging
What is the Best Sort Order for a Column Store? 2012-07-27 Data Modeling 8 Comments Compression, Data Warehouse, Statistics
Modeling Dimensions with History Tracked, Generic Attributes 2012-07-06 Data Modeling 5 Comments Data Warehouse, Dimensional Models, Historizing, Predictability, Query Plans
The Information Staircase 2012-07-01 Data Modeling 1 Comment Abstraction, Architecture, BI, Data Warehouse, ETL, Staging
Why “Date BETWEEN FromDate AND ToDate” is a dangerous join criteria 2012-06-29 Data Modeling 12 Comments Data Warehouse, Dimensional Models, Histogram, Historizing, OLTP, Query Plans, Statistics
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
Don’t Become a One trick Architect 2011-12-08 Data Modeling 12 Comments Architecture, Cursors, Data Warehouse, ETL, HADOOP, Hardware, OLTP, XML
