We are excited to announce the release of SQL Enlight version 1.9.9.935.

What’s new in this update:

  • Adds 17 new analysis rules rules
    • EX0019 : Find references to non-existing objects and columns
    • EX0020 : Specified text found in comments
    • EX0021 : Check DROP TABLE statements in order to avoid unintentional data loss
    • SA0137 : BEGIN TRANSACTION statement is missing a following COMMIT statement
    • SA0138 : BEGIN TRANSACTION statement without ROLLBACK statement
    • SA0139 : The procedure argument type is not compatible with the procedure parameter type
    • SA0161 : Current database uses old SQL Server collation. To take full advantage of SQL Server features, for new development change the default installation settings to use Windows collations
    • SA0259 : The created object already exists
    • SA0260 : Parameter defined as nullable, but no default value provided
    • SA0261 : The number of characters per line should not exceed the configured value
    • SA0262 : Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
    • SA0263 : Temporary table is used before it has any data inserted
    • SA0264 : Temporary table created but not used as a table source
    • SA0265 : COMMIT statement without corresponding BEGIN TRANSACTION statement
    • SA0266 : ROLLBACK statement without corresponding BEGIN TRANSACTION statement
    • SA0267 : Table variable is used before it has any data inserted
    • SA0268 : Table variable is not used as a table source
  • Adds 6 metric rules
    • SEM001 : Comment lines count
    • SEM002 : Code lines count
    • SEM003 : Statements count
    • SEM004 : Cyclomatic complexity
    • SEM005 : DML statement complexity
    • SEM006 : Count of SQL modules
  • Fixes and enhancements in the standard analysis rules
    • SA0192 – The rule now ignores global variable assignments
    • SA0168 – Other types of zero literals are now supported.
    • SA0172 – The rule now considers exit paths, which fixes some false positives.
    • SA0174 – Fix target statement scope and exclude not applicable statements from the rule checks.
    • SA0254 – The rule now considers exit paths, which fixes some false positives. Also, consider cursor declarations made inside dynamically executed SQL string.
    • SA0258 – The rule now considers union clauses inside fetch statement when counting the number of select columns.
  • Other fixes and enhancements:
    • Command Line Tool – Added support for a new custom property `IncludeTragetsWithoutIssues`,  which to control whether to report all targets or only ones having issues.
    • Team settings – Fixed behavior when updating SQL Enlight to a new version that adds new analysis rules. The previous behavior was merging the new rules with the rules in the configured team settings template. This way the new rules were included in the analysis, which is not usually intended. The current behavior only updates the existing standard analysis rules when a Team Settings are enabled, without adding the new ones.
    • Fixes of some other minor issues.

We are happy to announce the latest update of SQL Enlight with version 1.9.9.919.

What’s new in this update:

  • Added support for integration SQL Server Management Studio 18
  • Added support for integration with Visual Studio 2019
  • Fixes and enhancements in the standard analysis rules
  • Fixes of user reported issues

We are happy to announce the release of SQL Enlight version 1.9.9.917.

What’s new the new version:

  • A new report command was added to the command line tool
  • Improvements of the generated analysis report and the report stylesheets
  • Fixes and enhancements in the standard analysis rules
  • Fixes of user reported issues

Happy New Year!

Today we are delighted to announce the release of SQL Enlight version 1.9.9.913.

What’s new and exciting in this new version:

We are pleased to announce the release of SQL Enlight  version 1.9.8.907.

Changes in this version:

  • Fix of a problem with Visual Studio 2017 integration
  • Fixed the Code Analysis TFS Checkin Policy integration with Visual Studio 2017
  • New exclude/include files options for the Code Analysis TFS Checkin Policy
  • Fixed some issues with high DPI support
  • Enabled inheritance of the analysis template
  • General fixes and improvements
  • Fixes and improvements in standard analysis rules
  • Fixes of user reported issues

After creating new versions of the T-SQL Beautifier and T-SQL Analyzer, we decided to combine both tools in one – T-SQL Beautilyzer.

T-SQL Beautilyzer

There are several usability improvements in the new version and it is completely free as before.

We will improve the online tool further, so if you have any ideas, suggestions, or comments, please feel free to contact us.

Thanks for the feedback and we hope you’d enjoy the new tool!

We are delighted to announce today’s release of SQL Enlight  version 1.9.8.893.

The enhancements in this release are:

  •  Support for sharing settings between teams with Team Settings
  •  A set of 31 new analysis rules
  • Fix of the Code Analysis TFS Checkin Policy
  • Fix of installer and another problem with SSMS 17 integration
  • General fixes and improvements
  • Fixes and improvements in standard analysis rules
  • Fixes of user reported issues

This is a list of the newly added rules:

We are happy to announce the release of SQL Enlight – 1.9.8.877.

The enhancements in this release are:

  • SQL Server 2017 RTM support
  • Added 14 new analysis rules
  • Fixed installer issue related with SQL Server Management Studio 17 integration
  • Fixed installer issue related with  with Visual Studio 2017 integration
  • Improvements in standard analysis rules

These are the newly added rules:

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

The enhancements in this release are:

  • SQL Server 2017 RC2 support
  • SQL Server 2017 T-SQL syntax support
  • Improvements in analysis rules related with system functions

Enhancements in the previous release candidate:

  • Integration with SQL Server Management Studio 17
  • Integration with Visual Studio 2017
  • SQL Server 2016 T-SQL syntax support
  • 2 new code refactorings
  • Command line and build task support for running code refactorings
  • Fixed a few code formatting issues
  • Enhancements in the analysis rules violations reporting
  • Fixes for issues reported by users
  • Other improvements, mainly internal

We are happy to announce the new SQL Enlight release candidate that is now available –  1.9.8.872-RC.

  • Integration with SQL Server Management Studio 17
  • Integration with Visual Studio 2017
  • Support for the T-SQL syntax enhancements introduced in SQL Server 2016
  • 2 new code refactorings
  • Command line and build task support for running code refactorings
  • Fixed a few code formatting issues
  • Enhancements in the analysis rules violations reporting
  • Fixes for issues reported by users
  • Other improvements, mainly internal