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.