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