,

Comparison of SQL Enlight editions

Main components and features supported by each edition:

Features

SQL Enlight

  SQL Enlight For SSMS 

Visual Studio Integration

Yes

No

SQL Server Management Studio Integration

Yes

Yes

Code Formatting

Yes

No

Refactoring

Yes

No

Static Analysis

Yes

Yes

Command Line Tool

Yes

 Yes*

MSBuild tasks

Yes

  Yes**

NAnt tasks

Yes

  Yes**

TFS Check-in Policies

Yes

No

Price

$ 295

$ 195

* Code formatting command is not supported.

** Code formatting tasks are not supported.

 

, ,

SQL Enlight 1.9.3.727 Release

We are very happy to announce final release of SQL Enlight 1.9.3.727.

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

, ,

SQL Enlight 1.9.3.714 Beta

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.

, ,

SQL Enlight 1.9.3.690 Beta

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

, ,

SQL Enlight 1.9.2.671

We are very happy to announce the release of the SQL Enlight 1.9.2.671 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.

, ,

SQL Enlight 1.9 Release

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

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 1.9.1.618 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
, ,

SQL Enlight 1.9 Beta 2

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.

, ,

SQL Enlight 1.9.0.587 Beta

After almost a year, we are very happy to announce the release of SQL Enlight 1.9.0.587 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.

Improvements

  • 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 1.9.0.587 and is available for download here.

, ,

SQL Enlight 1.8.1.541

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

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 1.8.1.541 is available for download here.

, ,

Automate Query Execution Plan Analysis with SQL Enlight 1.7.3.515

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