// blog
Blog / Articles
Technical deep-dives into licensing automation and ITAM engineering.
Building a QRadar Compliance Connector for Snow License Manager
How I built an ETL pipeline to bring IBM QRadar's EPS-based licensing into Snow License Manager — and the first data pull immediately revealed the client was out of compliance.
Building a Custom Fields Bulk Updater for Snow License Manager
How a 'simple' bulk update tool for a software development company turned into a three-version rabbit hole of dual-team classification merging, wildcard matching edge cases, and SQL optimization.
Encoding Java Compliance — A Version-Aware Rules Engine and Continuous Monitoring
How I encoded Oracle Java licensing rules into a SQL recognition engine and version-aware classification pipeline — cutting RED installations by 44% and turning periodic manual audits into ongoing monitoring.
Building an IT System Owner Notification System on Top of Snow License Manager
How I turned Snow License Manager's unused contract management into an automated expiration alerting system — delivering personalized notifications to IT system owners before contracts lapse.
Building a ChatGPT Enterprise Usage Compliance Connector for Snow License Manager
How I built a Python connector bridging OpenAI's Compliance API with Snow License Manager — and diagnosed false license revocations caused by transient API data gaps.
Building a Three-Module Fidelis Connector for Snow License Manager
Three security modules, three different data sources, one compliance dashboard — how I built an automated Fidelis connector for Snow License Manager.
Building a Server HW Monitoring System for Snow License Manager
How I built an automated alerting system for hardware changes and stale inventory across thousands of servers — from v1 prototype to v2 with 65% alert reduction.
Automating SQL Server SPLA — Dual Licensing Models, Automatic Cost Optimization
Per-VM or Physical Host? Two licensing models, two cost scenarios per cluster — how I built automatic cost optimization for SQL Server SPLA across mixed Standard and Enterprise environments.
Building Compliance Dashboards in Power BI for Snow License Manager
How I built Windows Server and SQL Server compliance dashboards through 26 combined versions — and what I learned about Power BI's fragile data transformation layer the hard way.