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