Author Archives: chip

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 will do). … Continue reading

Posted in Data, happytechnologist, SQL | Leave a comment

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 actually asked … Continue reading

Posted in Data, happytechnologist, Random Musings | Tagged , , | Leave a comment

No Man’s Sky – Finally! Nearly as good as Star Control II

I’ve long been on record (well, I’ve long said it I promise) that my favorite game ever is still Star Control II, and I’ve been waiting for a game to recapture what I loved about it. (You can download the … Continue reading

Posted in Gaming, Programming, Reviews, Video Game | 1 Comment

On Repeated Medical “testing”

I’ve blogged about this before, but I wanted to revisit because FiveThirtyEight, whom I love and adore, just posted about it again, in light of the recent Theranos problems. My last blog post was long, so let me simplify my … Continue reading

Posted in Healthcare, Rant | Leave a comment

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 business perspective, … Continue reading

Posted in Data, Gaming, Work | Leave a comment