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
Category: Python
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
NumPy another Iverson Ghost
Click here for a PDF version of this post. During my recent SmugMug API and Python adventures I was haunted by an Iverson ghost: NumPy An Iverson ghost is an embedding of APL like array programming features in nonAPL languages and tools. You would be surprised at how often Iverson ghosts appear. Whenever programmers are challenged … Continue reading NumPy another Iverson Ghost
Setting SmugMug Print Size Keywords with Jupyter and Python
For the last few weeks, my normal hobbies have been preempted by my obsessive refactoring of an old SmugMug keyword setting program. Many years ago I wrote a small application that helped me maintain meaningful SmugMug keywords. I used this application for years until inevitable software changes broke it. Replacing it with something better has … Continue reading Setting SmugMug Print Size Keywords with Jupyter and Python
Downloading SmugMug Captions with Python and Jupyter
This blog post started out as an experimental rendering of a Jupyter notebook. I wanted to see how difficult it would be to convert a notebook to a WordPress.com blog post. Even though Jupyter exports notebooks in HTML and Markdown they do not display well "out of the box." No doubt one could craft CSS … Continue reading Downloading SmugMug Captions with Python and Jupyter