SQL Enlight 1.9.8.893

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