SQL Enlight for Developers 2.0.7.108 Released

We’re pleased to announce the release of SQL Enlight for Developers 2.0.7.108. This update introduces long-awaited tSQLt test execution support, expands SQL Server Management Studio compatibility, and includes several improvements to analysis accuracy, stability, and usability.

What’s New

tSQLt Test Execution Support

SQL Enlight now includes built-in support for running tSQLt unit tests.

The new Test Explorer tool window lets you discover, organize, and execute tSQLt tests directly from SQL Server Management Studio. SQL Enlight also introduces new command-line (CLI) commands for discovering and running tests, giving developers the flexibility to execute database unit tests either from SSMS or from the command line.

This is the first step toward deeper test integration within SQL Enlight, making it easier to combine static code analysis and database unit testing in a single workflow.

Analysis Improvements

This release includes several improvements to the analysis engine for more accurate results:

Fixed data type resolution of integer literals assigned to bit variables (for example, SET @Flag = 1 where @Flag is a bit), improving the accuracy of related analysis rules.
SA0230 now fully supports case-sensitive databases, eliminating false positives in environments that use case-sensitive collations.

SQL Server Management Studio Improvements

Added a fix for a critical issue in SQL Server Management Studio 22 where temporary SQL documents were not analyzed correctly.

Fixes and Improvements

Fixed sorting issues in the SQL Enlight Error List, providing a more consistent experience when reviewing analysis results.
Included several additional fixes, stability improvements, and performance enhancements throughout the product.