SQL Enlight Code Quality For SonarQube 2.1.1

We are excited to announce the new release of the new version 2.1.1 of our SQL Enlight Code Quality plugin for SnarQube.

This update includes several improvements and fixes:

• The analysis engine now supports more rules that can operate without requiring an SQL connection, using only the analysis context.

Analysis rules enhancements and fixes:

• The following rules can now operate solely with the analysis context: SA0040, SA0041, SA0047, SA0048b, SA0049B, SA0051, SA0122, SA0139, SA0237, SA0238.
• Enhanced cross-database support for these rules: SA0040, SA0047, SA0048b, SA0049B, SA0051, SA0095, SA0114B, SA0122, SA0126, SA0131, SA0137, SA0237, SA0238, SA0246.
• Updates to improve type resolution for these rules: SA0124, SA0126, SA0132.

Other enhancements and fixes in analysis rules:

• SA0042b: Fixed an issue that was preventing the reporting of issues found inside SQL modules.
• SA0051: Corrected a false positive related to PIVOT/UNPIVOT operators.
• SA0079: Fixed issue rule not being applied due to incorrect rule type
• SA0092b: Resolved an issue preventing reports and added default values for QUOTED_IDENTIFIER and ANSI_NULLS.
• SA0126: Fixed the assignment operator issue in WITH clauses.
• SA0139: Addressed a false positive when NULL is used as an argument.
• SA0172: Improved detection of unsafe usage of non-NVARCHAR variables in dynamic SQL.
• SA0237: Added parameters to ignore tables with identity columns.
• SA0263: Enhanced detection of dynamic SQL usage issues.

The SQL Enlight Code Quality plugin is available for download here; details about it can be found here.