Category Archives: happytechnologist

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

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

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 that, as … Continue reading

Posted in Data, Software, Work | Leave a comment

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, according to … Continue reading

Posted in Data, happytechnologist, Healthcare | 1 Comment