, ,

SQL Enlight For Developers 2.0.0.35

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

 

, ,

SQL Enlight 1.9.9.968

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
, ,

SQL Enlight 1.9.9.967

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.
, ,

SQL Enlight 1.9.9.964

We are excited to announce the release of SQL Enlight with version 1.9.9.964.

What’s new in this update:

  • New analysis rule SA0271. The rule checks T-SQL statements and reports usages of any of the configured as not recommended syntax for column aliases.
  • New analysis rule  SA0272. The rule checks for SELECT statements not having neither WHERE nor JOIN clauses.

Fixes and improvements in the standard analysis rules

  • Fixed a common analysis rule problem related to CROSS/OUTER APPLY operators not taken into consideration when selecting table sources
  • Fixed false positives in analysis rules SA0124, SA0126, SA0132 related to incorrect resolution of MIN/MAX aggregate functions return type
  • Fixed SA0060 – named parameters are not considered
  • Addressed overlapping problem with analysis rules – SA0150 and SA0166
  • Fixed analysis rule SA0266 false positive related to not considering the @@trancount check

Other fixes and improvements:

  • Fixed unhandled exception while analyzing document in Visual Studio
  • Fixed parser support for named unique index set in column definition using INDEX keyword syntax
  • Fixed problem with the command-line tool, where a comma is not accepted as a list separator when passing multiple file paths
  • Fixed parsing error related to OVERRIDE token not accepted by the parser as an identifier
  • Improved performance of the filtering of active or selected analysis rules
, ,

SQL Enlight 1.9.9.961

Today we released a hotfix update of SQL Enlight with version 1.9.9.960.

Issues fixed in this update:

  • Fixed a database metadata caching issue, which caused database changes not to be loaded until a restart of SSMS or Visual Studio.
, ,

SQL Enlight 1.9.9.960

We are delighted to announce the latest release of SQL Enlight with version 1.9.9.960.

What’s new in this update:

Issues fixed in this update:

  • Unhandled exception in SQL Enlight ErrorList on scroll
  • Team Settings UI setting to display validation errors on Team Settings enabled or disabled.
  • Issues in EX0018 and SA0131 related with sometimes pointing to wrong line and column
  • False positives in SA0145, SEM008, SA0172, SA0121 analysis rules
  • Formatting of multipart identifier data type in a variable declaration
  • Error when parsing a query that combines a large number of union-ed statements
  • Formatting of TOP clause
  • Other minor issues found in the previous version
, ,

SQL Enlight 1.9.9.953

We are pleased to present the latest release of SQL Enlight with version 1.9.9.953.

What’s new in this update:

  • Enhancement of rule SA0147. The rule now computes cognitive complexity.
  • Added a new metric rule SEM005 to compute cognitive complexity.
  • Enhancement of rule EX0025. The rule now does not require analysis context or connection and supports 1 and 2 part target column names.
  • Fix for the installer to set InstallLocation.
  • Fix for an issue in the upgrade of the analysis template.
  • Performance improvements of the TFS check-in policy.
, ,

SQL Enlight 1.9.9.950

The current update addresses some issues that were fixed in the previous release or were reported later.

What’s new in this update:

  • Addressed an issue related to the loading metadata of databases that have many SQL modules
  • Addressed an issue related to failing to extend the evaluation period
  • Addressed some other minor issues
, ,

SQL Enlight 1.9.9.946

After the previous release, we found some issues that could break in some cases the of SQL Enlight extension in VS and SSMS and we now release an update with a hotfix, which also includes some other issues that we fixed.

What’s new in this update:

  • Fixes and enhancements in the standard analysis rules
    • SA0266 – fixed false positives
  • Other fixes and enhancements:
    • Fix for an issue with index metadata loading issue with SQL Server 2016
    • Fix for an issue with upgrading settings and analysis template to the new version
    • Fix for an issue with cache settings – invalid or a not accessible cache path breaks the extension
    • Fixes of some other minor issues
, ,

SQL Enlight 1.9.9.945

We are delighted to announce the release of SQL Enlight version 1.9.9.945.

What’s new in this update:

  • Added 1 new analysis rules:
  • Fixes and enhancements in the standard analysis rules
    • SA0035 – enhanced the rule and fixed false positives when HACK, TODO or UNDONE is matched, but inside another word
    • S0048B – added a parameter to ignore temporary tables
    • SSA0049B – added a parameter to ignore temporary tables
    • SA0066B – enhanced rule message to include the schema of the parent table of the matched column
    • SA0075B – added a parameter to ignore temporary tables
    • SA0169 – added parameter, which to allow @@ROWCOWNT in  the first trigger statement
    • SA0184 – fixed matching and false positives
    • SA0225 – enhanced the rule to support target table names with three-part names
    • SA0254 – added support for direct dynamic SQL code and fix false positives when cursor used in try/catch blocks
    • SA0262 – fix some issues with the rule,  false positives and exclude analytic over clauses from aggregate
    • SA0263 – ignore temporary tables used in dynamic SQL code
    • SA0264 – added support for dynamic SQL code
    • SA0268 – enhanced the rule to consider cursor select statements
  • Other fixes and enhancements:
    • Enhancements and fixes in SQL comments formatting
    • Fixes of some other minor issues