, ,

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