Putting the Contract Under CI/CD: Database Deployments You Can Trust
So far in this series the database has a published interface (the ) and a read surface that you keep stable even when an wants to bind straight to your tables. Both of those are…
Idempotent Data Patches in SQL Server: A Change Tracking Pattern for DACPAC Deployments
If you deploy your SQL Server databases with SSDT or DACPACs via SqlPackage, you have probably run into this problem: the schema deployment is repeatable, but the data patches are not. SSDT handles CREATE TABLE,…