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 the analysis rules.

This new direct queries support, even not being exceptional by its means is quite useful and important and enables new opportunities for not only implementing static code analysis rules, but also for dynamic database analysis with SQL Enlight.

Major new improvements

• direct database querying support inside analysis rules
• support for SQL Server 2008 R2
• support for Visual Studio 2010
• analysis and layout running tasks now support cancellation
• the default analysis template now includes 22 new analysis rules since the last SQL Enlight release  1.7.1.502

New analysis rules

The analysis rules added since the latest analysis template are:

SA0056 : Index has exact duplicate or overlapping index.

SA0057 : Consider using EXISTS predicate instead of IN predicate.

SA0058 : Avoid converting dates to string during date comparison.

SA0059 : Check database for objects created with different than default or specified collation.

EX0009 : Consider adding proper comment block before each database object create statement.

EX0010 : Identify missing indexes using dynamic management views information.

EX0011 : Identify inefficient indexes using dynamic management views information.

EX0012 : Displays memory usage information for the current database.

EX0013 : Identify fragmented indexes that need rebuilding or reindexing.

EX0014 : List the last execution status of all available SQL Server jobs.

EX0015 : Find Best Clustered Index

EX0016 : Generate DROP INDEX statements for inefficient indexes using dynamic management views information.

EX0017 : Generate ALTER INDEX statements for rebuilding or reorganizing fragmented indexes.

Some of the new rules (SA0056, EX0010,EX0011,Ex0012,Ex0013, Ex0014,Ex0015,Ex0016 and Ex0017) are based on the information from the SQL Server Dynamic Management Views and Functions,  and utilize the new SQL Enlight feature for supporting direct SQL Server queries.

You can find the whole list of analysis rules included in the default analysis template here.