Configuring SQL static analysis checks
Published 21 May 2018
As well as running unit tests and code coverage, your SQL Toolbelt license entitles you to configure SQL Code Guard static analysis checks as part of your automated build and test process. This ensures coding consistency across the entire development team.
The SQL Code Guard command line can target a live database, a .sql script, or an entire folder of .sql scripts.
Download the command line here. You will need the executable and the appropriate dlls to be installed on your build agent or copied to your build agent via your check-out folder.
Further documentation is available on the SQL Code Guard documentation pages.
Pro tip: To ensure that the same checks are run in development as well as part of your build process, the rule set can be imported use the /config switch against the settings file saved by the SQL Code Guard SSMS add-in..