On the testing aspect - The TSQLT assembly (https://tsqlt.org/ https://tsqlt.org/) is an attempt at unit testing within MSSQL. It works okayish for what it is.

On the testing aspect - The TSQLT assembly (https://tsqlt.org/ https://tsqlt.org/) is an attempt at unit testing within MSSQL. It works okayish for what it is. I've at least found it to be nice when testing inputs for SQL functions and procedures, as well as some business rules within tables and views. A few IDEs provide integrations for TSQLT: Management Studio with the redgate extension, Datagrip, maybe others.