, ,

SQL Enlight Beta

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.

, ,

SQL Enlight

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.

, ,

Automate Query Execution Plan Analysis with SQL Enlight

Version of SQL Enlight is already released and available for download.

Here is what’s new in this release:

  • Extended query execution plan analysis support
  • A new analysis rule for query execution plan analysis – EX0018
  • A new external template parameter support in the command line tool and MSBuild tasks
  • Small improvements and fixes

The new parameter is added to provide a way to set external analysis template which to be used during analysis instead of the default one. Check the SQL Enlight documentation for the command line tool and MSBuild tasks parameters.

As the Execution Plan Analysis is the most important feature update in this release, here we have prepared a separate post for it.

We will be happy to help you if you have any questions or comments.

Thank you!

, ,

SQL Enlight

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.

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.

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

, ,

SQL Enlight

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

– Unicode support added for identifier names.

Example of unicode identifiers usage

– 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.


Analysis template updated

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.

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 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!