Home · Blog
Practical guides for DBAs, data engineers, and architects working with SQL Server, Azure SQL, Synapse, and Microsoft Fabric.
SQL Server 2016 hit end of support on July 14, 2026. Before you move to Azure SQL or SQL MI, you need to know which stored procedures, views, and functions call each other — and which objects are the highest-risk to touch.
SQL Server has been tracking the full object call graph the entire time your database has been running. Stored procedures, views, functions, cross-database references — all of it. Most teams only discover this when something breaks.
Before you migrate a legacy SQL Server warehouse to Microsoft Fabric or Azure Synapse, you need to answer a harder question than "which workload goes first" — you need to know what each workload depends on.
The four catalog sources that together reveal a table's full dependency footprint — expression dependencies, the DMVs, foreign keys, triggers — with copy-paste queries and the blind spots that bite during migrations.