One of the most exciting features in SQL Enlight is the ability to create your own static analysis rules. This is very powerful feature which can be of great use and unleash almost unlimited number of possibilities for the ones who consider trying it.

The current post is the first of a series of blog posts which to guide you through the creation of custom static code analysis rules with SQL Enlight. Each of the subsequent articles will cover the implementation of several interesting analysis rule and will point some unfortunately not so obvious features and abilities of SQL Enlight static code analysis engine.

Read the rest of this entry »

We are happy to announce the release of our new online T-SQL Analyzer.

The T-SQL Analyzer uses the SQL Enlight static code analysis engine to check T-SQL code for compliance with best practices.

The online tool supports the following set of analysis rules: all rules from SA0001 to SA0039 and also rules SA0042, SA0043, SA0051, SA0053 and SA0054.

You can check here for more information about the analysis rules.

The SQL Enlight analysis templates are XML files that contain analysis rules and analysis groups definitions. The templates can be imported in SQL Enlight and this way can update or add new rules to the currently supported set of rules. Read the rest of this entry »