Category: Uncategorized

As so often happens, I had an issue at work today that turned into (I think) a great blog/video idea.  Let’s start with a simple scenario: We have two tables, each 2 columns wide, each with a 2 column composite key – meaning that (col1, col2) make up the unique primary key together.  We want […]

Code Sins: Formatting (1 min 26 sec) I declare Code Sin #1: poorly formatted code. Look, the video’s uner 90 seconds long…watch it. Your successors, your coworkers — your CHILDREN, will thank you.

Oops, make that TEN vids in the last two weeks. Here you go: Grouping Sets