Ethanol is Excrement in the Gas Tank

Like many U.S. government programs, the blended corn ethanol mandate has done little to address its avowed goals, i.e., strengthen energy security, reduce carbon emissions, and lower prices for consumers. By some accounts it, consumes more energy than it produces, increases consumer prices, distorts food production, wastes vast tracts of arable land, and contributes to … Continue reading Ethanol is Excrement in the Gas Tank

Running SSIS Packages with Python

Click here for a PDF version of this post. Microsoft's SSIS (SQL Server Integration Services) is a ubiquitous ETL (Extract Transform and Load) tool. Despite its widespread use, SSIS is not loved! At best, it's tolerated for its undeniable utility, but SSIS's “utility” comes with a host of hideous warts with the ugliest being its … Continue reading Running SSIS Packages with Python

Better Blogging with Jupyter Notebooks on WordPress.com

When I discovered Jupyter notebooks a few years ago I instantly recognized their potential as a technical blogging tool. Jupyter notebooks support mixtures of text, mathematics, program code, and graphics in a completely interactive environment. It's easy to convert notebook JSON .ipynb files to markdown, $latex \LaTeX$, and HTML so it's not a big leap … Continue reading Better Blogging with Jupyter Notebooks on WordPress.com

Extracting SQL code from SSIS dtsx packages with Python lxml

Click here for a PDF version of this post. Lately, I've been refactoring a sprawling SSIS (SQL Server Integration Services) package that ineffectually wrestles with large XML files. In this programmer's opinion using SSIS for heavy-duty XML parsing is geeky self-abuse so I've opted to replace an eye-ball straining1 SSIS package with half a dozen, … Continue reading Extracting SQL code from SSIS dtsx packages with Python lxml