Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.
Edge Constraints: Controlling Which Nodes a Graph Edge Connects
An edge table with no rules accepts nonsense links. Add an edge constraint, watch the bad edge fail, and see what the constraint still does not check.
Polymorphic Associations: Why One Column Cannot Point at Many Tables
One column that points at many tables cannot be enforced by SQL Server. Here is the demo, the orphans it allows, and a design that says no to bad rows.
A Multi-Tenant Schema With a TenantId Column: Keys, Indexes and Safety
Design a multi-tenant schema with composite keys, tenant-first indexes, trusted session context, and row-level security checks.
Rolling Out Database Changes Gradually
Roll out database changes gradually with expand-and-contract steps, feature flags, data checks, and a rollback path for each stage.
DACPAC vs BACPAC Quiz: Which File Carries Your Data?
This DACPAC vs BACPAC Quiz asks which file moves a database with its rows to Azure SQL Database. The answer is the BACPAC. A tested script shows what each file describes, and the SqlPackage commands show how to use them.
Counting Users, Roles and Orphans in Every Database
Audit counting users across databases, include roles and schema ownership, and distinguish orphaned SQL users from contained identities.