Thank you for this article.

One note regarding to the modifications of stored procedures through drop/create technique.

When you behave in such a way you will lose security settings for targeted stored procedure.

For example,

1. DBA assigned "execute" permission for certain user with name "ExampleUser".

2. During application update stored procedure has been recreated using drop/create.

3. User "ExampleUser" is not able to execute this stored procedure as it has been deleted earlier.

This can be significant issue on Production environment and it will be difficult to explain for end users why permissions have been lost.

Be aware about this issue.