We have just released 9 brand new analysis rules for SQL Enlight. (more…)

Today we released an update of SQL Enlight 1.7 which includes several usability improvements:

- Unicode support added for identifier names.

- Context only rules are now applied when analyzing server objects using the command line tool and the MSBuild tasks. This feature was missing in the previous release.

- The Context Only rules are can be applied either with using Analyze with Specific Rules… command or when analyzing databases or servers. For instance, the Context Only rules will be skipped when a stored procedure is analyzed, but will be included when a database is selected for analysis from Object Explorer. The Context Only rules will be always applied when explicitly selected.

- Each analysis rule can be separately configured whether to require its parameters to be entered before analysis or not to require parameters. This way, the parameters dialog won’t be shown when rules with no required parameters are selected, but then the default rule parameter values will be used.

- A new Error list command which to instantly show the SQL Enlight Error List window is now added to the SQL Enlight menu.

You can find and download the updated SQL Enlight version here.

The updated analysis template includes fixes of rules SA0011 , SA0040 and SA0047. These rules had problem with matching specific rule violations inside views and table valued functions.

You can download the updated template here.

We are happy to announce the final release of SQL Enlight 1.7.  The tool is available for download here.

Improvements and new features in SQL Enlight 1.7

• Integrated analysis rules are removed – now all rules are customizable.
• Analysis context – server details and database schema are now available during static code analysis and can be used in the analysis rules.
• Parameterized analysis rules – analysis rules can have parameters that to be specified before analysis.
• Executed statements history – new feature for saving reusing executed queries in SQL Server Management Studio.
• Improved analysis rule designer – support the new analysis context, testing of XPath expressions, tree views of test query SQML and analysis.
• Explicit analysis group – rules in that group can be executed directly from the SQL Enlight menu.
• Export and import of analysis rules and analysis templates – analysis template and analysis rules now can be exported and easily shared between team members.
• Analysis before executing T-SQL script – analysis can be configured to be run just before executing T-SQL code in SSMS.
• Analysis rule selection before analysis – now you can choose which rules to use just before running the analysis.
• Extended SSMS object explorer analysis menu – the menu now allows using specific analysis group or analysis rule separately.
• Support for several XPath extension functions including support for the http://exslt.org extension modules.
• New analysis rules – the default analysis template now includes 19 new static analysis rules.

Thank you all, for your feedback and suggestions! You helped us in creating all the great new features in the current SQL Enlight release!

Hope you will enjoy it as much as we do!

What’s new in SQL Enlight 1.7 BETA

• Improvements in analysis rules designer.
• Implemented several XPath extension functions including support for the http://exslt.org  extension modules.
• Support for Statistics in analysis context.
• Updates of some of the analysis rules – EX0001, EX0002 and EX0003.
• SQML optimization. See the changes in SQML that may affect your custom analysis rules.

Previous release improvements and new features

• Integrated analysis rules are removed and now all rules are customizable.
• Analysis context – server details and database schema are now available during analysis and can be used in the analysis rules.
• Parameterized analysis rules – analysis rules can have parameters that to be specified before analysis.
• Executed statements history – new feature for saving reusing executed queries in SQL Server Management Studio.
• Improved analysis rule designer – support the new analysis context, testing of XPath expressions, tree views of test query SQML and analysis.
• Explicit analysis group – rules in that group can be executed directly from the SQL Enlight menu.
• New analysis rules – the default analysis template now includes 9 more rules ( 5 of them are explicit rules ).
• Export and import of analysis rules and analysis templates – analysis template and analysis rules now can be exported and easily shared between team members.
• Analysis before executing T-SQL script – analysis can be configured to be run just before executing T-SQL code in SSMS.
• Analysis rule selection before analysis – now you can choose which rules to use just before running the analysis.
• Extended SSMS object explorer analysis menu – the menu now allows using specific analysis group or analysis rule separately.

We have planned the release of the final version at the beginning for the third week of February 2010.

The beta version in now available for download here.