We are excited to announce the release of the latest version of SQL Enlight for Build Machines – 1.1.6.19.

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 pleased to announce the release of the latest version of SQL Enlight for Build Machines – 1.1.5.16.

Here’s what’s new in this update:

  • Fixed a metadata loading problem that caused server object analysis to fail and some SQL modules to be skipped
  • Improved EX0018 analysis rule issue marking
  • Enhanced CLI tool results with a summary of the top 10 violated analysis rules

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 happy to announce the latest release of SQL Enlight for Build Machines version 1.1.5.15.

Here’s what’s new in this update:

  •  We have fixed a metadata caching problem that caused unnecessary cache invalidation.
  •  We have also fixed the issue where the exitCodeOnViolations was not considered when analyzing files or databases.
  •  Lastly, we have removed the requirement for the licenseKey argument when running analysis, refactoring and formatting commands

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 latest SQL Enlight For Build Machines version 1.1.4.14 release.

What’s new in this update:
  • Added SQL connection and query timeout multiplier for increasing default timeouts
  • Whitelist improvements and fixes
  • Enhancements in the  Analysis AutomationApi
  • Fixed an issue with the decryption of encrypted SQL modules
  • Fixed a problem with issue suppression marks
  • Minor fixes and improvements

We are delighted to announce the latest SQL Enlight For Build Machines version 1.1.4.13 release.

What’s new in this update:
  • Enhancements  in the issue suppression – support for start/end block, a reason for suppression, and suppressed issue reporting in summary
  • Enhancements in the  Analysis AutomationApi and its documentation
  • Update standard analysis rules to the latest version
  • Analysis performance improvements
  • Minor fixes and improvements

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

Here is what’s new in this release:

  • align the rules and analysis engine with the latest SQL Enlight For Developers version 2.0.2.81
  • update analysis rules to the latest versions
  • fixed integration issue with Developer and Enterprise SonarQube editions
  • support for the latest SonarQube releases
  • added support for demo mode

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

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