How to use Liquibase to migrate MS SQL Server to Oracle

Jul. 20, 2015 by

I’m a certified SQL Server DBA, a certified Oracle DBA, and I’ve used liquibase before, so I thought that using liquibase to migrate a schema definition from SQL Server to

How to use views as enumerations and constants to avoid magic values in TSQL

Jul. 14, 2015 by

Good quality code uses very few string literals or unnamed numerical constants. Wikipedia does a great job of explaining why not to use magic values. I’ll summarise: Magic values make

Dimensional Modelling Advice

Jun. 23, 2015 by

Dimensional Modelling is hard. It lacks both the mathematical precision and the maturity of Codd’s Normal Forms. That’s because the dimensional model is about the unknowable future needs of the

PL/SQL Parameters

Jun. 16, 2015 by

In my professional opinion, the most productive innovation of object-oriented languages is that they naturally lead to passing an entire set of data rather than a series of possibly unrelated simple

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