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

Improvements in this update:
  • Added new XSLT functions – sqml:is and sqml:in
  • The current SQL Enlight version is now added to the exported analysis rules
Fixes in this update:
  • Fixed issues in Code Fixes of analysis rules SA0020 and SA0253
  • Fixed an error that could appear in some cases when loading metadata for database files

We are happy to announce the latest SQL Enlight For Build Machines version 1.1.4.7 release.

This update includes several performance improvements in this:
  • Enhanced analysis and analysis rules performance.
  • Resolved significant performance issues in rule SA0122 related to column and object resolution
  • Optimized performance of several other rules:
    EX0019,EX0020, EX0025, SA0004, SA0012, SA0016, SA0026, SA0035, SA0053B, SA0080, SA0081, SA0095, SA0117, SA0124, SA0125, SA0130, SA0132, SA0144, SA0183, SA0230, SA0232, SA0247B, SA0269, SEM001

 

We are excited to announce the latest release of SQL Enlight For Build Machines version 1.1.4.3.

These are the more significant fixes and improvements in this version:

  • Full support for the new T-SQL syntax introduced in SQL Server 2019 and SQL Server 2022
  • Fix for an issue in the code formatting, which caused an internal transformer error – ‘se:’ prefix was not defined
  • Fix for an issue in the SA0184 analysis rule, which not reporting comparisons in double brackets
  • Fix for an issue in the identifier resolution, which caused false positives and negatives in the analysis results

 

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

These are the fixes and improvements in this version:

  • Fixed code formatting issues
  • Fixed an issue with case-insensitive objects resolution
  • Fixed RE0004 and RE0005 refactorings and the other refactorings that use SQL Server metadata

We are excited to announce the latest release of SQL Enlight For Build Machines version 1.0.3.

The update includes several console and performance improvements:

  • Enhancements of the console output and details
  • New rules:
    • SA0274 – The first statement in the script, must be USE statement.
    • SA0273 – The USE statement must be the first statement in the script.
  • Support for demo mode allowing limited use without a trial license
  • Fix for a major performance problem