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

What’s New in Version 1.1.8.24:

  • Performance Improvements
    • Significant optimizations have been made to improve the performance of analysis, refactoring, and code formatting operations.
  • Enhanced Analysis Rules:

    • Two new analysis rules for safer and more consistent CASE expressions:
      •  SA0278 detects mismatched data types between the input and WHEN expressions in simple CASE statements.
      •  SA0279  reports inconsistent data types among the result expressions of CASE statements.
    • SA0124 now properly checks for implicit conversions and provides clearer issue details.
    • SA0126 has been updated to correctly handle CASE expressions.
    • Several analysis rule descriptions and examples have been clarified and corrected.
  • Improved Type Resolution:

    •  Data type resolution has been further improved for more accurate and reliable static code analysis.

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.8.24 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 pleased to announce the release of SQL Enlight for Developers 2.0.4.99. The release comes with performance enhancements, smarter analysis, new rule additions, and full support for the SSMS 21 General Availability release.

🛠️ What’s New in Version 2.0.4.99:

  • Performance Improvements
    • Significant optimizations have been made to improve the performance of analysis, refactoring, and code formatting operations.
  • Enhanced Analysis Rules:

    • Two new analysis rules for safer and more consistent CASE expressions:
      •  SA0278 detects mismatched data types between the input and WHEN expressions in simple CASE statements.
      •  SA0279 reports inconsistent data types among the result expressions of CASE statements.
    • SA0124 now properly checks for implicit conversions and provides clearer issue details.
    • SA0126 has been updated to correctly handle CASE expressions.
    • Several analysis rule descriptions and examples have been clarified and corrected.
  • Improved Type Resolution:

    •  Data type resolution has been further improved for more accurate and reliable static code analysis.
  • SSMS 21 GA Support:

    • SQL Enlight now fully supports the official SQL Server Management Studio 21 GA release

This release enhances SQL Enlight’s ability to detect and resolve SQL issues, improves performance, and adds support for the official release of SQL Server Management Studio 21.

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

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!

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

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.