Entries by admin

Online T-SQL Analyzer

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. […]

,

SQL Enlight 1.7.2.509

We are very excited to announce that the latest and greatest version of SQL Enlight, version 1.7.2.509, is now available for download. The new release of SQL Enlight includes: several usability improvements, 13 absolutely new analysis rules, and at last but definitely not at least is the support for directly executing database queries from within […]

, ,

SQL Enlight 1.7.1.502.

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 […]

Updated analysis template avaliable for download

Today we released an updated analysis template for SQL Enlight. The template includes a fix of analysis rule ‘SA0044: Consider creating statistics on all composite index columns’. There was a problem with the previous version and it was outputting the incorrect column as candidate for creating statistics.  You can download the updated template here.

, ,

SQL Enlight 1.7 RTM

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 […]

,

SQL Enlight 1.7 BETA

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 […]