Ryan Robitaille

"Dream Big and Dare To Fail"

Ahoy! I'm a data [hacker, engineer, artist, rebel, slayer, janitor, tool builder] who also dabbles in design (if you could call it that). Whatever goofy name-of-the-week you want to call it, I'm a problem solver.
I get shit done.

Data is quickly becoming the silent lifeblood of our modern society; I try to help it get from point A to point B, sometimes point A is an indecipherable mess, and sometimes point B is human understanding (but not both at the same time hopefully).

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 […]

4 August 2009 0 Comments

You can pet my Goat. Just wash your hands first, please.

I tried to feed a goat a tin can once. He wouldn’t eat it. Cartoons have steered me wrong once again. Besides… the supervising Goat master scolded me before the Goat had a chance to fully understand the situation he was being put in. Maybe that particular Goat had diabetes and wasn’t allowed to eat […]

29 July 2009 20 Comments

Using a simple Python script for End-to-End Data Transformation and ETL (Part 1)

In the Data Transformation Services (DTS) / Extract Transform and Load (ETL) world these days we’ve got a LOT of expensive ass products. Some are good, some are marginal, and some are pieces of over-complicated (and poorly performing) java-based shit. But, hey, enough with the negativity – I digress, I just want to show you […]

16 July 2009 2 Comments

I don’t mind ugly people, but I do mind people who make ugly faces…

I saw a girl today crossing the street in front of me as I patiently sat at a red light. My first reaction was pretty neutral – I thought, “Eh, its just some cute, young college girl” – my city is full of them due to all the schools in the capital district, and they […]

15 July 2009 2 Comments

The State of Flow, Hidden Passions, and Drudgery

Have you ever had an activity that you became totally lost in – where time either flashed by in an instant or seemed to stand still – your entire concentration was on that task at hand and the rest of the world just kind of faded away temporarily? Well, then you have experienced the “State […]

14 July 2009 1 Comment

Bike Path + Reflective Sunglasses = Mean Walkers

This is just a test of the FlipCam + uploading to YouTube + Posting in WordPress. Don’t expect anything amazing.

13 July 2009 1 Comment

The UFC needs a Michael Jordan, not a Michael Vick

You stay classy, Brock Lesnar! Before you think I’m just writing a rant (which it is), take a minute to think about how this relates in the marketing world. Its somewhere between an industrial accident and a PR stunt, depending on where the truth lies and who you believe. Either way, its creating a new […]

Page 5 of 512345