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

How to Write Dynamic SQL Well

Dec. 1, 2014 by

Dynamic SQL has a bad reputation. When I started as a DBA I had a code quality checklist that had dynamic SQL on it as a problem. I later wrote