SQL Enlight Code Analysis extension for Visual Studio Team Services and Team Foundation Server consists of build task can be added to the build definition. The task analyses T-SQL code against best practices and its output can be easily combined with the build test results.
There are more than standard 230 analysis rules, which to ensure code quality, detect potential defects and check against best practices.
SQL Enlight supports creation of custom rules, which can be also used by the TFS/VSTS extension.
The SQL Enlight Code Analysis build task can be followed by Publish Test Results task, which to publish the analysis results as test results.
For support, please write an email to email@example.com.