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

We are delighted to release a new SQL Enlight for Developers update – version 2.0.1.53.

These are the fixes and improvements in this version:

  • Fixed code formatting issues
  • Fixed an issue with case-insensitive objects resolution
  • Added Automatic Fix to rule SA0136
  • Fixed RE0004 and RE0005 refactorings and the other refactorings that use SQL Server metadata
  • Fixed issues in the Automatic Fix of rules SA0001, SA0017 and SA0191

We are pleased to release a new SQL Enlight for Developers update – version 2.0.1.50:

These are the fixes and improvements in this version:

  • Remove dependency on .NET 2.0
  • Fixed issue with the automatic code fix of rule SA0191
  • Fixed a problem with the refactorings that require a SQL connection
  • Fixed a problem with code formatting settings for semicolons that closes the Options form
  • Add support for detecting Visual Studio and SSMS theme changes

We are happy to release a new SQL Enlight for Developers update – version 2.0.1.48:

  • Fix SSMS 19 integration issue
  • Rule designer – match suggestions enhancements
  • 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.

This update addresses the following issues found in version 2.0.1.43:

  • Changes made by a bulk fix of analysis issues are not applied in the produced script file
  • Мetic rule results are incorrectly included in the CLI tool analysis report

We are excited to announce the release of version 2.0.1.43 of SQL Enlight For Developers.

This update contains several improvements and a fix for a significant performance issue in the analysis feature.

New features and enhancements:

  • Added Code Issue Fix suggestions to Code Editor
  • When applying a fix to a database and multiple SQL module issues, all the fixes are written to a single script document
  • User experience improvements in the CLI tool
  • Added support for integration with Visual Studio 2022
  • Added support for integration with SQL Server Management Studio 19 Preview 2

Fixes in this version:

  • Analysis feature – major performance problem
  • Other minor fixes and improvements