What includes this update:

  • Optimizations of the analysis feature
  • Fixes and improvements

Here is what’s changed in this update:

  • Performance optimizations of the analysis feature
  • Fix for LinqBridge.dll validation error

We are happy to announce that the next update of SQL Enlight is already here.

Here is a summary of what’s new in version

  • Support for SQL Server 2014 – T-SQL syntax enhancements and new schema features
  • Support for analyzing SQL Azure databases
  • The Command line tool, NAnt and MSBuild tasks can now accept regular expressions for filtering analysis target objects
  • Several performance optimizations of the analysis feature
  • Fixes and improvements

The new SQL Enlight version can be downloaded here and new version of SQL Enlight for SSMS can be downloaded here.


Until now, only MVPs and trainers are entitled to free SQL Enlight Licenses.  Now everyone who authors a custom analysis rule and shares it with the SQL Server Community can also get a free personal license of SQL Enlight For SSMS worth $145.

What you will have to do?

1. Think of a new useful custom analysis rule and implement it.

2. Write a blog post that describes the practice, which it is enforcing and share the rule’s xml file.

You have your rule and post ready, what’s next?

Simply email your rule to rules@ubitsoft.com or send us link to a blog post describing the rule. Once we check the rule we will give you a free SQL Enlight For SSMS license.

Wondering where to start?

First download and install the latest version of SQL Enlight or SQL Enlight For SSMS.

The Analysis Rule Designer which comes with the tools is not limited by the trial period and you can freely use it to learn create and test your analysis rules.

Here is some resources, which you can use:

More Resources:
We are preparing a step by step tutorial for how to create a custom rule with SQL Enlight and will add a link to it in this post as soon as we have the tutorial published.

If you have any questions, please feel free to contact us.

This is a SQL Enlight For SSMS review by Grant Fritchey, which was published on Simple Talk last week:

Grant’s review gives a detail look to the features of the tool and its use.

The article is recommended to anyone as an introduction to the tool.

This week we released an update for SQL Enlight and SQL Enlight for SSMS version
The update include the following improvements common to both editions:

  • Small improvements and fixes
  • Improved Analysis rules selection dialog:

    The new rules selection dialog adds some useful filters and allows the rule parameters to be set in a single step.

  • Changes specific to SQL Enlight:

    • Added support for Visual Studio 2013

    Changes specific to SQL Enlight For SSMS:

    • NAnt tasks which were missing in the previous version are now included

    Download SQL Enlight and SQL Enlight for SSMS here.

Main components and features supported by each edition:


SQL Enlight

  SQL Enlight For SSMS 

Visual Studio Integration



SQL Server Management Studio Integration



Code Formatting






Static Analysis



Command Line Tool



MSBuild tasks



NAnt tasks



TFS Check-in Policies




$ 295

$ 195

* Code formatting command is not supported.

** Code formatting tasks are not supported.


We are very happy to announce final release of SQL Enlight

We did a several fixes and improvements to the tool in this release.

Here is a summary of what’s new in version 1.9.3:

  • There are 62 new analysis rules
  • Support for Visual Studio Solution and Projects  analysis
  • Analysis feature usability improvements
  • Reorganized and enhanced Options dialog
  • Several fixes,optimizations and smaller improvements

You can download and try the final release of SQL Enlight here.


SQL Enlight For SSMS

We also released a new special edition of SQL Enlight focused on the T-SQL static analysis –  SQL Enlight For SSMS.

The new edition includes all SQL Enlight analysis features as well as improved integration with SQL Server Management Studio.

The SQL Enlight For SSMS is developed as a part of the Red Gate Ecosystem Project  and uses the advanced integration framework provided by the ecosystem.

You can download and try the new edition here.

Another beta version of SQL Enlight is available for download here.
The new version includes the following:

  • Fixes of the reported and found issue so far
  • A new look of the Options dialog

If you find any issues in the new version, please report them using our support email.