Hey Steve,
Great article, and thanks for sharing.
You discussed whether to use create procedure or create a stubb proc and do an alter. Finishing off with "I'm not sure which I like better, but I don't really think any of them are great".
Now, I'm no DBA so I may be talking hokum ... but as I understand it if you use "if exists drop proc" variation you lose any permissions allocated to the proc. The second version with the alter doesn't lose the permissions.
Now ideally we'd have permissions scripted as part of an upgrade procedure, but in real life permissions get added outside a normal release cycle.
Hence I tend to prefer creating a stubb and using alter, which may sway your indecision as to which is preferred 😉
Hope this helps.
Nailed it! We do a CREATE with initial permissions. All subsequent changes are ALTERs, which almost never have permission changes.