Fighting Bad Data Modeling
  • About Me
    • Musing
    • Game Guides
  • Subject Areas
    • Data Modeling
    • Databases
    • Programming
  • Resources
    • Database Conventions
    • Source Code
    • Free Data
    • Utilities
    • Slides
  • SQL Server Archive
    • Courses
      • Performance Tuning Course
      • Data Warehousing Course
    • Grade of the Steel

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

  • 2014-05-01
  • SQL Server Archive
  • No Comments
  • Data Warehouse, ETL, Staging

The Curse of Self-Service

  • 2013-08-18
  • Musing
  • No Comments
  • BI, Data Warehouse, Master Data
Column Store Feature Image

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
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
Boxing Ring

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

  • 2012-01-28
  • Data Modeling
  • No Comments
  • Architecture, Data Warehouse
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
123Next Page

Thomas Kejser

Fighting Bad Data Modeling

Copyright © 2021 - Thomas Kejser