Insights
Practical guides on SQL Server, SSIS, lineage, monitoring and automation — written from the problems we solve on real data estates.
Find views, procedures, SSIS packages and Power BI datasets that depend on a SQL Server table — with sys.dm_sql_referencing_entities, recursive dependency queries and what they miss.
Query msdb and SSISDB to find failed SQL Agent jobs and SSIS executions, slow runs, missing rows and stale data — and turn the queries into monitoring.
Detect SQL Agent and SSIS failures, capture diagnostics and create Jira issues through the REST API — with deduplication, routing and secure credentials.
Tell us about your SQL Server, SSIS, Azure or Power BI environment — and what's getting in the way. You'll talk to an engineer, not a sales script.