Tag Archives: Data Warehouse

Guidance on warehouse modeling and tuning in the Inmon and Kimball world

Shooting yourself in the foot

SELECT INTO – Moving Data From A to B

The Curse of Self-Service

Column Store Feature Image

What is the Best Sort Order for a Column Store?

Modeling Dimensions with History Tracked, Generic Attributes

2012-07-06
Data Modeling
No Comments
Data Warehouse, Dimensional Models, Historizing, Predictability, Query Plans

Information Staircase

The Information Staircase

2012-07-01
Data Modeling
No Comments
Abstraction, Architecture, BI, Data Warehouse, ETL, Staging

Radiation no digging

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

INSERT vs UPDATE

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

A DW Venn Diagram

Bill Lumberg trying to think

Don’t Become a One trick Architect

2011-12-08
Data Modeling
No Comments
Architecture, Cursors, Data Warehouse, ETL, HADOOP, Hardware, OLTP, XML