TRY/CATCH Custom Message – SQL Error Handling

Crediting Basa for neat details, check out his blog is full of good things. The idea is to control the message returned to the app front-end, rollback the transaction if need be or retry with another command. More on this...with how to log the activity as well. Thanks, Hiram

Batching SQL Scripts to Automate Deployments (with .bat/cmd)

With this technique, you don't have to buy anything or spend time installing fancy stuff. Just write some commands, copy/paste and save as .bat or cmd. [Not discrediting any other implementation, just sharing my experience with a simple method]. When you end up running the batch I recommend doing it on the target server, not your workstation…