We are excited to announce the release of SQL Enlight for Developers, version 2.0.3.87.

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.
  • The AnalysisContext CLI command can now generate metadata for multiple databases in a single context file and export SQL module definitions.

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.

We have just released an update for SQL Enlight for Developers version 2.0.2.84.

This update includes a hotfix for an SSMS 20 integration problem. If there were no earlier SSMS versions installed on the user’s environment, the installer previously skipped the SSMS 20 integration.

This issue has now been resolved.

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.83.

The main improvements in this update are:
  • Added support for SQL Server Management Studio 20
  • Enhanced EX0018 analysis rule to mark the first statement keyword
  • Enhanced CLI tool results with a summary of the top 10 violated analysis rules

Fixes in this update:

  • Fixed a metadata loading problem that caused server object analysis to fail and some SQL modules to be skipped
  • Other smaller fixes and improvements

We are delighted to announce the SQL Enlight for Developers update to version 2.0.2.82.

The main improvements in this update are:
  • Added SQL connection and query timeout multiplier for increasing default timeouts
  • Enhanced the whitelist to completely skip analysis of target server and database SQL modules when the whitelist entry has specific no target rules provided

Fixes in this update:

  • Fixed problem with issue suppression marks
  • Fixed an issue with the decryption of SQL modules
  • Fixed an issue in the whitelist that makes the TargetRules property not to be considered
  • Internal fixes and improvements

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.81.

The main improvements in this update are:
  • Enhancements  in the issue suppression – support for start/end block, a reason for suppression, and suppressed issue reporting in summary
  • Enhanced the whitelist with support for files
  • Add Export/Import commands to the settings of the whitelist
  • Enhanced Team Settings export to export analysis template as a separate file for direct use in SonarQube
  • Enhanced SA0124, SA0126, SA0132, and SA0139 analysis rules with bit/integer type resolution of constants 0 and 1
  • Added New analysis rule SA0275 for tracking suppression comments
  • Enhancements for the bulk edit of Analysis Rules
  • Analysis performance improvements

Fixes in this update:

  • Fixed slow multi-selection  in the error list and its details panel
  • UI and UX fixes and improvements
  • Internal fixes and improvements

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.77.

The main improvements in this update are:
  • Enhancements of the Snippets tool windows inside the Analysis Rule Designer  – added descriptions to the XSLT functions
  • Added new XSLT functions – sqml:is and sqml:in
  • Add support for bulk editing of analysis rules in the Active Analysis Rules List. Multiple rules can now be selected and a few of their common properties can be changed.
  • The current SQL Enlight version is now added to the exported analysis rules

Fixes in this update:

  • Fixed issues in Code Fixes of analysis rules SA0020 and SA0253
  • Fixed an issue in the Active Analysis Rules List that after filtering, the selected rule is not the first one in the list
  • Fixed an error that could appear in some cases when loading metadata for database files

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.74.

The update contains an improvement and optimizations to the last TFS check-in policy related to the “New Code Only” analysis feature, which we released in the previous version.

We are delighted to announce the SQL Enlight for Developers update to version 2.0.2.73.

The main improvements in this update are:
  • Added a new setting to the TFS check-in policy – to report only issues in the new code
  • Some minor optimizations and fixes in the TFS check-in policy
  • Enhancement in the License Wizard to allow checks for available renewals of the subscription period
  • Fixed an installer bug when SSMS or Visual Studio are installed on a different drive than the target drive

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.70.

 The update includes performance improvements and minor fixes of issues found in the previous release.

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.69.

We made several performance improvements in this update:
  • Enhanced analysis and analysis rules performance.
  • Resolved significant performance issues in rule SA0122 related to column and object resolution
  • Optimized performance of several other rules:
    EX0019,EX0020, EX0025, SA0004, SA0012, SA0016, SA0026, SA0035, SA0053B, SA0080, SA0081, SA0095, SA0117, SA0124, SA0125, SA0130, SA0132, SA0144, SA0183, SA0230, SA0232, SA0247B, SA0269, SEM001