t-sql

For this month’s T-SQL Tuesday, James Anderson’s chosen theme is shipping database changes. Hoo, boy, have I got some scars to talk about. I’ve been a developer who had to deploy changes, a DBA who had to deploy other peoples’ changes, an open source maintainer, and even been a software vendor who had to hand other people scripts to deploy in their own environment. Here’s some of the things I assumed over the years – only to learn the hard way that they weren’t always true: The deployment script you were given is the most recent one. The deployment script will…