Posted on March 13, 2017
Greedy Test Case Algorithm in a SQL Stored Proc
Here’s a straightforward problem: I have a table with a lot of fields in it (in this case, several tables — new Fact and Dimension tables in a star schema data warehouse, but, you know, any wide table… Read More
Posted on August 23, 2016
Horses and Olympians and Data and Such
I pick on Aaron Carroll a lot, and it’s really not that he deserves picking on, it’s in fact because he writes so much good stuff that I like that I am compelled to investigate at length.  Fortunately this time he… Read More
Posted on January 25, 2016
On Key Performance Indicators
You’ve got a company, or an organization, or even just in everyday life, and you have goals: you want to grow, you want to learn, you want to educate. But how do you quantify those goals? From a… Read More
Posted on January 8, 2016
Base conversion in SQL
Here’s something silly I threw together that no one will probably use, which makes it perfect for posting here. We ran across software that has a table that has an Id that ALSO has a unique char(4) field… Read More
Posted on May 7, 2015
When the “Quantified Self” meets Medical Reality
So, there was a bit of a twitter row a few weeks ago when Mark Cuban and a number of healthcare people got in a debate about the frequency of lab testing. Â Mark posted a tweet that started,… Read More