Sep
26
2017

Oregon's New Distracted Driving Law

In August of 2017 Oregon law makers signed HB 2597 into law. Often referred to as the Distracted Driving Law, HB 2597 adds a series of new restrictions on what you're allowed to do with your phone. Unfortunately, coverage of this bill and what exactly it means for you as an individual has left m...

Aug
18
2017

Aggregating Using Unpivot

A common task when analyzing data concerning a population is to determine how various subpopulations compare to one another. If the sub populations are nonoverlaping populations, a simple group by clause will usually solve your problem. When they overlap however, you have to find other solutions.

Jul
28
2017

When Join Order Matters

It's a popular belief that the order of a SQL query's join order doesn't matter so long as the joins are done as an inner join [1]. In a simple world, this is true. Unfortunately, life is rarely so simple.