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 file handling. You would think that an ETL tool … Continue reading Running SSIS Packages with Python
Tag: Python
NumPy another Iverson Ghost
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 with processing large numeric arrays they rediscover bits of … Continue reading NumPy another Iverson Ghost
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
Analyze the Data not the Drivel 