SQL Cover is a tool to measure code coverage in T-SQL. This will tell you how much of your database code your unit tests are exercising.
You can read more about it:
https://the.agilesql.club/blogs/Ed-Elliott/2016-04-08/SQLCover-Code-Coverage-For-SQL-Server-T-SQL
You can get the source code from:
https://github.com/GoEddie/SQLCover
You can download it from:
https://github.com/GoEddie/SQLCover/releases/
For help feel free to ping me.
Articles / Posts about SQL Cover: https://www.red-gate.com/blog/building/sql-cover https://documentation.red-gate.com/display/SR1/Using+SQL+Cover+with+SQL+Release+PowerShell+cmdlets http://www.jankowskimichal.pl/en/2016/09/sql-unit-tests-coverage-report/?utm_campaign=shareaholic&utm_medium=twitter&utm_source=socialnetwork
Redgate: Redgate kindly sponsored the initial version of SQLCover and I am most greatful to David Atkinson who really helped to shape what we have ended up with.