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: ETL

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
Shooting yourself in the foot

BULK INSERT with Linux Line Endings

  • 2014-04-03
  • SQL Server Archive
  • No Comments
  • ETL, SQL Server
Information Staircase

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

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
Zombie vs Sheep

Physically Placing the Maps in the architecture

  • 2011-08-19
  • Data Modeling
  • No Comments
  • Architecture, Data Warehouse, ETL, Keys, Maps, Master Data, Staging
Zombie vs Sheep

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
Zombie vs Sheep

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
12Next Page

Thomas Kejser

Fighting Bad Data Modeling

Copyright © 2021 - Thomas Kejser