, ,

SQL Enlight For Build Machines 1.1.7.23

We’re delighted to announce the release of SQL Enlight for Build Machines 1.1.7.23.! This update is packed with improvements to analysis rules and type resolution.

🛠️

What’s New in Version 1.1.7.23:

Type Resolution Enhancements:

  • Enhanced the type-checking and improved the type resolution to support most of SQL Server’s functions, types, and expressions.

Enhanced Analysis Rules:

  • Enhanced the rules SA0124, SA0126, SA0132, SA0139, SA0238, SA0246, and SA0276 to reflect the improvements in the type resolution.
  • Resolved an issue in SA0028 where the CAST function was not correctly considered.
  • Improved documentation of all analysis rules.

New Analysis Rule:

  • Added a new analysis rule, SA0277, to detect possible implicit conversion, truncation, or data loss when the inserted or updated value is incompatible with the target column type.

Code Formatting Fixes:

  • Addressed a formatting issue where comments after BEGIN keywords in BEGIN/END blocks were not placed on a new line.

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.7.23 now from our website.

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

, , ,

Enabling SQL Enlight in SSMS 21 Preview

Microsoft has released the SQL Server Management Studio 21 Preview, and we’re excited to announce that SQL Enlight for Developers version 2.0.3.96 now supports it!

By default, SQL Enlight should be available under the Extensions menu in SSMS 21. However, in the SSMS 21 Preview, you may not see the extension listed there. To enable SQL Enlight to appear in the main menu, you need to follow a one-time setup.

Step-by-Step Guide to Enable the SQL Enlight Menu

  1. Launch SQL Server Management Studio 21 Preview.
  2. Navigate to the Extensions Menu: Although SQL Enlight is supposed to appear under the Extensions menu by default, it may not be visible.

  1. Customize the Menu:
    • Go to Extensions → Customize Menu…
    • In the customization window, locate the SQL Enlight item in the list.
    • Uncheck the checkbox next to the SQL Enlight item. This one-time action moves the SQL Enlight menu to the top-level menu, similar to earlier SSMS versions.
  2. Confirm the Changes: After unchecking the box and restarting SSMS, the SQL Enlight menu will appear in the main menu.

By following these steps, you’ll have SQL Enlight accessible in your main menu for easier navigation and use.

, ,

SQL Enlight For Developers 2.0.3.96

🚀 SQL Enlight 2.0.3.96 Released! 🚀

We’re excited to announce the release of SQL Enlight 2.0.3.96, packed with improvements to analysis rules, type resolution, and SQL Server Management Studio (SSMS) support.

🛠️ What’s New in Version 2.0.3.96:

  • Enhanced Analysis Rules:

    • Enhanced the rules SA0124, SA0126, SA0132, SA0139, SA0238, SA0246, and SA0276 to reflect the improvements in the type resolution.
    • Resolved an issue in SA0028 where the CAST function was not correctly considered.
    • Added a new analysis rule, SA0277, to detect possible implicit conversion, truncation, or data loss when the inserted or updated value is not compatible with the target column type.
    • Improved documentation of all analysis rules.

  • Improved Type Resolution:

    • Enhanced the type-checking and improved the type resolution to support most of SQL Server’s functions, types, and expressions.

  • SSMS 21 Support:

    • Added support for SQL Server Management Studio 21 (Preview).

  • Code Formatting:

    • Addressed a formatting issue where comments after BEGIN keywords in BEGIN/END blocks were not placed on a new line.

This release strengthens SQL Enlight’s ability to detect and resolve SQL issues while improving performance and integration with the latest preview version of SQL Server Management Studio.

📥 Download SQL Enlight 2.0.3.96 today and check out the full release notes on our website!

Your feedback helps us improve—let us know your thoughts! 🚀

, ,

SQL Enlight Code Quality For SonarQube 2.1.3

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.

, ,

SQL Enlight For Build Machines 1.1.6.21

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!

, ,

SQL Enlight For Developers 2.0.3.93

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

, ,

SQL Enlight 1.9.9.975

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!

, ,

SQL Enlight Code Quality For SonarQube 2.1.2

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.

, ,

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.

, ,

SQL Enlight For Developers 2.0.3.87

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.