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

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

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:

• SA0169 : Use @@ROWCOUNT only after SELECT, INSERT, UPDATE, DELETE or MERGE statements
• SA0170 : It is recommend to not use CTE unless it is need for Hierarchical data
• SA0171 : The ROW_NUMBER paging pattern can be replaced with OFFSET FETCH clause
• SA0172 : The dynamic SQL is constructed using external parameters, which is not ensured to be safe
• SA0173 : COALESCE, IIF, and CASE input expressions containing sub-queries will be evaluated multiple times
• SA0174 : The CASE expressions should not rely on short-circuit behavior with aggregate functions or full text search predicates
• SA0175 : Extract input expression as a variable in order to ensure it is invariant and avoid unexpected results
• SA0176 : Consider merging nested IF statements to improve readability
• SA0177 : To improve code readability, put only one statement per line
• SA0178 : LIKE operator is used without wildcards
• SA0179 : Do not create function and procedures with too many parameters
• SA0180 : CASE expression has too many WHEN clauses
• SA0181 : The query joins too many table sources
• SA0182 : The CASE expressions is missing ELSE clause
• SA0183 : The commented out code reduces readability and should be deleted
• SA0184 : Redundant pairs of parentheses can be removed
• SA0185 : Review the call for unintentionally passing the same value more than once as an argument
• SA0186 : Possible missing BEGIN..END block
• SA0187 : Duplicated string literals complicate the refactoring
• SA0188 : The NULL or NOT NULL constraint not explicitly specified in the table column definition
• SA0189 : Store procedure executed without getting a result
• SA0190 : Numbered stored procedures are deprecated
• SA0191 : Procedure body is not enclosed in BEGIN…END block
• SA0192 : Procedure returns more than one result set
• SA0193 : Avoid unused labels to improve readability
• SA0194 : The ELSE clause is not needed.If it is omitted the CASE expression will still return NULL as default value
• SA0195 : Duplicate statistics must be removed
• SA0196 : Deprecated use of DROP INDEX with two-part index name syntax
• SA0197 : The deprecated FASTFIRSTROW hint was encountered
• SA0198 : Usage of deprecated GROUP BY ALL syntax encountered
• SA0199 : Usage of deprecated COMPUTE clause encountered

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