Automating SQL joins that follow foreign keys

Oct. 18, 2017 by

I’ve written a SQL code generator which automates the mindless, repetitive task of joining a table to the tables to which it has foreign keys. Generating this code isn’t exactly

How to test a view in a SQL database

Sep. 27, 2017 by

I had a realisation that I’m looking forward to blogging about soon. ¬†However, when I outlined my post I couldn’t find references for several things that I know to be