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

We are pleased to release version 2.0.0.37 of SQL Enlight For Developers.

The most significant aspect of this update, besides some small fixes, is the command-line interface, which is now available also for the Developers edition.

We are delighted to announce the release of the new major version 2.0.0.35 of SQL Enlight.

We have prepared some compelling new features in this release:

  • In the Analysis Rule Designer, there are numerous enhancements – such as match suggestions, snippets, and simple rule expressions. See Analysis Rule Designer documentation for more details.
  • New Simple Analysis Rule type that uses XPath match expressions and can be created using a few mouse clicks.
  • Support for automatic fixing of code and database analysis issues – currently about 30 analysis rules have automatic fixes.
  • Support for creating custom fixes for code and database rules.
  • New analysis rule properties  – technical debt properties and separate ‘How to fix’ description. The new properties will be used in the reporting and will allow some other view of the analysis results.
  • The new Analysis Whitelist allows databases and objects to be excluded from the analysis results.

With the new major version of SQL Enlight, there are some changes to our licensing model:

  • We divided SQL Enlight into two editions – SQL Enlight for Developers and SQL Enlight for Build Machines.
  • We replaced the perpetual license for a major version with an update and support subscription combined with a perpetual fallback license for all the releases before the subscription end date.
  • There are also changes to the Commercial and Personal license prices.

To be able to introduce the new improvements, we had to discontinue the support for the old SQL Server Management Studio and Visual Studio versions. SQL Enlight 1.9 will continue to work with the old SQL Server Management Studio and Visual Studio versions, but new fixes and features will only be released for newer versions of SSMS and VS.

These are the SSMS and Visual Studio versions that are not supported anymore:

  • SQL Server Management Studio 16
  • SQL Server Management Studio 2014
  • SQL Server Management Studio 2012
  • SQL Server Management Studio 2008 R2
  • SQL Server Management Studio 2008
  • Visual Studio 2015
  • Visual Studio 2013
  • Visual Studio 2012
  • Visual Studio 2008
  • Visual Studio 2005

 

We are happy to announce the release of SQL Enlight with version 1.9.9.968.

Improvements in this update:

  • Added parser support to ALTER DATABASE SCOPED CONFIGURATION statement for the new options introduced in SQL Server 2019.
  • Added parser support for new in SQL Server 2019 option – OPTIMIZE_FOR_SEQUENTIAL_KEY
  • Added parser support TOP clause with floating-point number expression such as TOP 99.99

We are happy to announce the release of SQL Enlight with version 1.9.9.967.

Fixes and improvements in this update:

  • Fix issues with analyzing case-sensitive SQL Server instances and databases.
  • Fix syntax error when parsing IF/ELSE statements followed by a THROW statement or a WITH CTE clause.
  • Fix analysis rule SA0184 false positive related with TOP clause.
  • Enhanced analysis rule SA0020 with a rule parameter for ignoring temporary tables and table variables.
  • Fix some other minor issues.