My career is building software development teams

Jun. 11, 2015 by

Even though I’ve read Lawrence Corr’s book, Agile Data Warehouse Design, several times and have been applying its teachings in my work, I learned a lot from his three day

Blue-Green Extract Transform Load

Jun. 5, 2015 by

Do your Extract Transform Load (ETL) batch loads sometimes fail? Do your customers want to reduce the duration of the window during which the warehouse is unavailable while the loads

Comparing sets in SQL

Feb. 24, 2015 by

I was shown the following technique for comparing tables when I was a junior programmer many years ago. WITH A as (SELECT something) , B as (SELECT another_similar_thing) SELECT *

Drop if exists considered harmful

Dec. 16, 2014 by

I read lots of examples on the internet that check if an object exists, and then drop it before creating it. You’d be excused for thinking that this is good

Redshift Zone Maps as an “indexing” strategy

Dec. 8, 2014 by

I’ve been looking at Redshift Zone Maps for some time, and so I was quite pleased with theRedshift session that Rahul Pathak delivered at re:Invent 2014. Redshift is a columnar