Here are the slides from my talk today at the Redgate NYC Devour Hour: Architecting Zero Downtime Deployments.pptx
The Repo is here: https://github.com/way0utwest/ZeroDowntime
An interesting question on feature toggles: Would you use Extended Properties for a feature toggle flag?
My answer:
I wouldn’t. I find Extended Propeties (and triggers) to be hidden inside databases and I don’t like hidden things. They fall through the cracks, it’s hard to remember they exist, and more. Plus Extended properties aren’t easily programmed.
I would love
alter table add (or update) extended property
and a way to query these
select * from table.properties
Instead we have a messed up sp_add/update property with a very, very unintuitive set of parameters.