Working SQL code can be generated via an ORM or written directly, but most common code analysis techniques don’t help your confidence that the SQL code is “good.” Ideally, you can check the SQL code in a database or in source control for antipatterns to detect code that performs poorly, severely limits future structural changes, or doesn’t match your code formatting guidelines. There are several libraries capable of analyzing your T-SQL code and your selection will depend on your development and deployment workflows.

In this session we’ll review the SqlCheck, ScriptDOM, and SQL projects code analysis options such that you can confidently add code analysis to the SQL components of your applications.