We are happy to announce the release of a new version 2.1.3 of our SQL Enlight Code Quality plugin for SnarQube.

This update includes fixes for rules SA0139 and SA0092B and adds a new analysis rule, SA00276, to detect variable assignment truncation and conversion issues.

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

We’re thrilled to announce the release of SQL Enlight for Build Machines 1.1.6.21! This update brings several fixes and improvements, and a new analysis rule to enhance your automated SQL analysis workflows.

🛠️ What’s New in Version 1.1.6.21:

Metadata and Performance Enhancements:

  • Fixed metadata loading issues for improved reliability and performance.

Enhanced Analysis Rule Accuracy:

  • Fixed type resolution issue in analysis rule SA0139.
  • Fixed inconsistent behavior in analysis rule SA0092B.

New Analysis Rule:

  • Added analysis rule SA00276 – detects truncation and conversion issues in variable assignment.

Code Formatting Fixes:

  • Corrected formatting issues with CREATE OR ALTER phrases being incorrectly split across lines.

This release ensures your build environments have the latest tools for detecting and resolving SQL issues. Upgrade today and experience faster, more reliable analysis for your automated processes!

📥 Download SQL Enlight for Build Machines 1.1.6.21 now from our website.

Your feedback is invaluable to us—let us know how we can make SQL Enlight even better for you!

We’re excited to announce the release of SQL Enlight For Developers 2.0.3.93! 🚀 This version brings numerous improvements, fixes, and a brand-new analysis rule to enhance your SQL code quality and development experience.

🛠️ Highlights of the Update:

Metadata and Performance Enhancements:

  • Fixed metadata loading issues to improve reliability and performance.

Analysis Rules Improvements and Fixes:

  • Fixed a type resolution issue in the SA0139 analysis rule.
  • Fixed inconsistent behavior in the SA0092B analysis rule.

New Analysis Rules:

  • The new SA00276 rule detects truncation and conversion issues with local variables and parameters.

Code formatting Fixes:

  • Fixed a formatting issue where the phrase CREATE OR ALTER could be incorrectly split across lines.

This release is part of our ongoing commitment to deliver robust tools for SQL developers. Update to the latest version to take advantage of these improvements and keep your SQL code in top shape!

📥 Download SQL Enlight For Developers 2.0.3.93 now from our website.

Your feedback helps us improve SQL Enlight – let us know what you think! 🚀

We are pleased to announce the release of SQL Enlight 1.9.9.975.

This maintenance update is focused on resolving issues related to database metadata loading that may affect analysis reliability and performance.

📥 Download SQL Enlight 1.9.9.975 from our website to benefit from these improvements.

Thank you for your continued support and feedback—it helps us improve SQL Enlight with every release!

We are happy to announce the release of a new version 2.1.2 of our SQL Enlight Code Quality plugin for SnarQube.

This update adds full support for SonarQube 10.6 and some improvements to the demo mode.

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

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.

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 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