Archive | December, 2009

30 December 2009 4 Comments

Get Clicky Android Widget = Awesomely Convenient

If you’re like me (exactly maybe, as scary as that might be) and have a Motorola Droid, and use Clicky for awesome and simple web analytics – you’ll want this. Its only 1 dollar – which is the same as a double cheeseburger at McDonalds (if you local vendors participate – since we all know […]

8 December 2009 5 Comments

Using XLWT and Python to export an Oracle dataset to Excel (Python Simple ETL Part 2)

A few months ago, I showed how you can do simple back and forth ETL task with python scripts – this time I’m going to take it one step further and show how with an extra python module we can actually export data to a usable Excel format as well. I often use this method […]

1 December 2009 1 Comment

Cut-N-Paste Corner: Microsoft SQL Server 2000, 2005, 2008 Simple Loop Template

I think that ‘data wrangling’ takes a special kind of problem solving mentality. Keeping data current, cleaning it, merging it, aggregating it, and creating summary (or data warehouse) tables for reporting purposes… For MANY years I used Express installations of SQL Server 2000 as my ultimate data Swiss Army knife. It was like a secret […]