Extracting SQL code from SSIS dtsx packages with Python lxml

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, "as simple as possible but no simpler", Python scripts. … Continue reading Extracting SQL code from SSIS dtsx packages with Python lxml

Common Table Expression (CTE) SQLServer Queries with J

I've been blogging long enough to observe that your awesome posts are often ignored while your little "one-offs" sometimes strike hit gold. This is particularly true for "code example" posts. When I'm trolling for code --- the geek equivalent of trolling for babes --- I don't want to read about the author's programming philosophy or what the hell … Continue reading Common Table Expression (CTE) SQLServer Queries with J