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