SQL Enlight 1.9.8.893

By Blog Author
#releases #sql-enlight-v1 #sql-enlight

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]- https:/sqlenlight.com/help_19/html/b91c6917-2e08-42ad-9caa-643368c20f16.htm)
  • [SA0170 : It is recommend to not use CTE unless it is need for Hierarchical data]- https:/sqlenlight.com/help_19/html/7b47b106-9cf7-4a60-a8d4-3b54cd54b353.htm)
  • [SA0171 : The ROW_NUMBER paging pattern can be replaced with OFFSET FETCH clause]- https:/sqlenlight.com/help_19/html/af37f033-0f76-45c9-befe-b72c284ca4fc.htm)
  • [SA0172 : The dynamic SQL is constructed using external parameters, which is not ensured to be safe]- https:/sqlenlight.com/help_19/html/2e87c243-1fd5-4306-9f8b-0b6839e52c50.htm)
  • [SA0173 : COALESCE, IIF, and CASE input expressions containing sub-queries will be evaluated multiple times]- https:/sqlenlight.com/help_19/html/01523e5e-e184-476f-bfce-7656e734ae58.htm)
  • [SA0174 : The CASE expressions should not rely on short-circuit behavior with aggregate functions or full text search predicates]- https:/sqlenlight.com/help_19/html/c5e214f3-7b20-45cc-a118-b25c6aaf7d6d.htm)
  • [SA0175 : Extract input expression as a variable in order to ensure it is invariant and avoid unexpected results]- https:/sqlenlight.com/help_19/html/cc33b155-07ab-4926-ba1f-c8a7b548bd3f.htm)
  • [SA0176 : Consider merging nested IF statements to improve readability]- https:/sqlenlight.com/help_19/html/ca159053-9d9d-46be-9528-9225a46bdda2.htm)
  • [SA0177 : To improve code readability, put only one statement per line]- https:/sqlenlight.com/help_19/html/7aaf8b22-c740-492a-989a-53a37ec81d6a.htm)
  • [SA0178 : LIKE operator is used without wildcards]- https:/sqlenlight.com/help_19/html/f6fc5e8b-6bb6-4b5f-9958-33312b6e780f.htm)
  • [SA0179 : Do not create function and procedures with too many parameters]- https:/sqlenlight.com/help_19/html/12cd60a3-da6b-4395-9dfb-2a650ac9a206.htm)
  • [SA0180 : CASE expression has too many WHEN clauses]- https:/sqlenlight.com/help_19/html/b5745dbd-5fab-43bd-bef1-236c00a1c655.htm)
  • [SA0181 : The query joins too many table sources]- https:/sqlenlight.com/help_19/html/5d783518-2efa-4c66-8a04-2750ac9ea651.htm)
  • [SA0182 : The CASE expressions is missing ELSE clause]- https:/sqlenlight.com/help_19/html/9d92c9d3-5368-4eab-8604-0b4588ab7611.htm)
  • [SA0183 : The commented out code reduces readability and should be deleted]- https:/sqlenlight.com/help_19/html/de376fd8-0c20-4941-9438-de7ef1af68b1.htm)
  • [SA0184 : Redundant pairs of parentheses can be removed]- https:/sqlenlight.com/help_19/html/884a6f00-b694-4c6b-8f65-416e253e858a.htm)
  • [SA0185 : Review the call for unintentionally passing the same value more than once as an argument]- https:/sqlenlight.com/help_19/html/3f731414-8ca9-4291-b6c5-4f8e0cab51f9.htm)
  • [SA0186 : Possible missing BEGIN..END block]- https:/sqlenlight.com/help_19/html/e77203f0-1024-460f-b7a3-7a2c00120422.htm)
  • [SA0187 : Duplicated string literals complicate the refactoring]- https:/sqlenlight.com/help_19/html/c04d63ab-e82f-41e4-b55f-9a7852a25211.htm)
  • [SA0188 : The NULL or NOT NULL constraint not explicitly specified in the table column definition]- https:/sqlenlight.com/help_19/html/516c8094-d9d6-4c3b-9c87-92ca3d5ae4d8.htm)
  • [SA0189 : Store procedure executed without getting a result]- https:/sqlenlight.com/help_19/html/b298ad2f-42c0-49f0-a898-37c39fce8f05.htm)
  • [SA0190 : Numbered stored procedures are deprecated]- https:/sqlenlight.com/help_19/html/01b103ff-c8ae-43b1-a1db-92ac2ceba180.htm)
  • [SA0191 : Procedure body is not enclosed in BEGIN…END block]- https:/sqlenlight.com/help_19/html/11922f56-2098-4f80-8c8e-54efbdbbf5ec.htm)
  • [SA0192 : Procedure returns more than one result set]- https:/sqlenlight.com/help_19/html/fa316afd-4ffd-4c1b-862e-dc9eb7084920.htm)
  • [SA0193 : Avoid unused labels to improve readability]- https:/sqlenlight.com/help_19/html/8d414795-6161-4a93-b909-b29618df986a.htm)
  • [SA0194 : The ELSE clause is not needed.If it is omitted the CASE expression will still return NULL as default value]- https:/sqlenlight.com/help_19/html/a096ffc9-b9f4-4305-bcbc-c6856d0dfa21.htm)
  • [SA0195 : Duplicate statistics must be removed]- https:/sqlenlight.com/help_19/html/3feeee99-b353-494a-b6f4-2c7431b556c8.htm)
  • [SA0196 : Deprecated use of DROP INDEX with two-part index name syntax]- https:/sqlenlight.com/help_19/html/64b18bd2-685d-4395-ab09-c1f1f64566d9.htm)
  • [SA0197 : The deprecated FASTFIRSTROW hint was encountered]- https:/sqlenlight.com/help_19/html/7f188eb5-fdb7-4e39-a2f8-cefaf270d285.htm)
  • [SA0198 : Usage of deprecated GROUP BY ALL syntax encountered]- https:/sqlenlight.com/help_19/html/6f826da8-757c-4ace-89df-3f0b59c65136.htm)
  • [SA0199 : Usage of deprecated COMPUTE clause encountered]- https:/sqlenlight.com/help_19/html/97053f06-5a2b-4844-9b30-f32921b2ef93.htm)
Back to Blog