We are very happy to announce that there is a new update of SQL Enlight which is now available for download. The version of the update is and it is now in beta.

Here is a list brief list of what-s new in the update:
– Added support for Visual Studio projects and solution analysis
– Added 62 new analysis rules
– Added a filter for analysis rules in the rule selection box
– Several fixes and smaller improvements

The update can be downloaded here.
Your feedback and comments will be of great help for the final release. Thank you!

We are very happy to announce the release of the SQL Enlight update which can be downloaded here.
Along with the fixes and improvements, this release adds the support for SQL Server 2012 T-SQL syntax and integration with SSMS 2012 and Visual Studio 2012.

That’s not the end with version 1.9 updates. Soon we are going to make available another which will add several new rules to the current set and will also add some improvements to the current Visual Studio integration.

As a final, we would like to give special thanks to Direct Supply team for their contribution and great feedback during the development of the current and the next updates.

We are very pleased to announce the final release of SQL Enlight

In this release, several issues were fixed and optimizations were made since the beta release.
We also included partial support for SQL Server Management Studio 2012 – currently only the integration with the main menu is available.

You can download SQL Enlight here.

In the next months we are going to release new updates of version 1.9 which will include the features we were not able to include in the current release.

Here is a short list of what we are planning to include in the next updates:

  • Full integration with SSMS 2012
  • Support for SQL Server 2012 T-SQL extensions
  • The postponed formatting improvements
  • Many New analysis rules

We are happy to announce the today’s we release of SQL Enlight 1.9 Beta 2.

Here are the main release notes:

The new version can be downloaded here.

After almost a year, we are very happy to announce the release of SQL Enlight Beta.
Here follows a list of the major new features and improvements that are included in it.

New Features

  1. Static Code Analysis TFS Check-in Policy. Both TFS 2008 and TFS 2010 are supported.
  2. Two new refectories:
    • Expand Wildcards
    • Add Statement Terminators
  3. Layout:
    • Option to ignore layout of selected statements
    • New comment layout options
  4. 25 new analysis rules. See here for complete list of the new rules.


  • Command line tool, NAnt and MSBuild tasks improvements now support recursive processing of folders and multiple target files.
  • Analysis rules – several extensions made available including.
  • Layout command – syntax errors will not stop the layout, but will just skip the source batch.
  • Automatic updates checking.
  • Memory usage optimizations.

Free features

The following features are now free to use and are not trial limited:

  • Validate SQL Code
  • Statements History
  • Summarize Script
  • Outline Statements

The version is and is available for download here.

We are very sorry, but we found a major problem in the latest release The problem in is that the database disk cache folder default value is not set correctly the first time the application is started. The missing setting affects the database analysis feature and makes it not usable.

We released a hotfix update – which has the issue fixed and can be downloaded here.

Please excuse us for the inconvenience caused by this problem.

We are happy to announce the release of the latest SQL Enlight version –

Here is what’s new in this release:

In addition to the above features, the new version includes updated analysis rules and a few other improvements and small fixes.

SQL Enlight is available for download here.

  • Query execution plan analysis support for functions
  • Extended query execution plan analysis support
  • One new analysis rule for query execution plan analysis
  • Small improvements and fixes

Last week we released a new version of SQL Enlight –
It contains just small fixes and 2 new features:

  • A new layout rule ‘Miscellaneous->Keywords padding’.
The layout rule controls the padding of the main keywords in SELECT, INSERT,UPDATE and DELETE  statements.
For example:

-- Keyword Padding option set to 10:
SELECT     ProductID ,
           SpecialOfferID ,
           AVG( UnitPrice ) AS 'Average Price' ,
           SUM( LineTotal ) AS SubTotal
FROM       Sales.SalesOrderDetail
WHERE      SpecialOfferID IN(  1 ,
                               2 ,
                               6 ,
                               9 )
GROUP BY   ProductID ,
ORDER BY   ProductID ,
           SpecialOfferID DESC

-- Keyword Padding option set to 0:

SELECT ProductID ,
       SpecialOfferID ,
       AVG( UnitPrice ) AS 'Average Price' ,
       SUM( LineTotal ) AS SubTotal
FROM Sales.SalesOrderDetail
WHERE  SpecialOfferID IN(  1 ,
                           2 ,
                           6 ,
                           9 )
GROUP BY ProductID ,
ORDER BY ProductID ,
         SpecialOfferID DESC
  • A new XSLT extension method ‘execute-query-plan’ which to enable support for query plan analysis.

We will describe in more detail the usage of this method in the next post.

The new version is already available for download here.

We are very excited to announce that the latest and greatest version of SQL Enlight, version, 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. Read more