We are happy to announce the SQL Enlight for Developers update to version 2.0.2.77.

The main improvements in this update are:
  • Enhancements of the Snippets tool windows inside the Analysis Rule Designer  – added descriptions to the XSLT functions
  • Added new XSLT functions – sqml:is and sqml:in
  • Add support for bulk editing of analysis rules in the Active Analysis Rules List. Multiple rules can now be selected and a few of their common properties can be changed.
  • 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 issue in the Active Analysis Rules List that after filtering, the selected rule is not the first one in the list
  • Fixed an error that could appear in some cases when loading metadata for database files

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.74.

The update contains an improvement and optimizations to the last TFS check-in policy related to the “New Code Only” analysis feature, which we released in the previous version.

We are delighted to announce the SQL Enlight for Developers update to version 2.0.2.73.

The main improvements in this update are:
  • Added a new setting to the TFS check-in policy – to report only issues in the new code
  • Some minor optimizations and fixes in the TFS check-in policy
  • Enhancement in the License Wizard to allow checks for available renewals of the subscription period
  • Fixed an installer bug when SSMS or Visual Studio are installed on a different drive than the target drive

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.70.

 The update includes performance improvements and minor fixes of issues found in the previous release.

We are happy to announce the SQL Enlight for Developers update to version 2.0.2.69.

We made several performance improvements in this update:
  • 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 SQL Enlight for Developers update to version 2.0.2.66, which includes some long-awaited features.

Improvements in this update:

  • Full support for the new T-SQL syntax introduced in SQL Server 2019 and SQL Server 2022
  • Support for the Multi-Factor Authentication in SSMS

Issues addressed in this update:

  • A problem in the code formatting, which caused an internal transformer error – ‘se:’ prefix was not defined
  • A problem in the SA0184 analysis rule, which not reporting comparisons in double brackets
  • A problem in the identifier resolution, which caused false positives and negatives in the analysis results

 

We are pleased to announce the new SQL Enlight for Developers update – version 2.0.1.58.

These are the fixes and improvements in this version:

  • Fixed issues in analysis rules – SA0068B, SA0069B and SA0075b
  • Enhancements in the rule designer
  • Added support for SSMS 19.0 – the latest general availability (GA) version
  • Enabled automatic synonym resolution in analysis rules

We are happy to announce the new SQL Enlight for Developers update – version 2.0.1.57.

These are the fixes and improvements in this version:

  • Fixed layout of the updates notification form
  • Added a new filter to the Error List for showing only the fixable issues

Today we released an update SQL Enlight for Developers version 2.0.1.56.

This update includes a fix for database metadata caching, which may cause unnecessary reloading of database metadata.

We are happy to announce the new SQL Enlight for Developers update – version 2.0.1.55.

These are the fixes and improvements in this version:

  • Fixed analysis rule SA0184 automatic fix issue
  • Fixed email activation problem in the license wizard
  • Fixed a common issue with the automatic fix of analysis rules