SQL Prompt 9

SQL Prompt 9.4 release notes

9.4.8.7733 - 16th January 2019

Fixes

  • SP-7373 : Fixed a bug where right-clicking on code analysis issues causes SSMS to freeze for some users.
  • SP-7364 : Fixed a bug where the insert semicolons refactoring failed when using SYSTEM_TIME ALL with an alias within a script.
  • SP-7414 : Fixed the removal of keyboard shortcuts for the Add/Remove Square Brackets, Expand Wildcards and Insert Semicolons refactorings.

9.4.7.7595 - 9th January 2019

Features

  • Code analysis: You can now automatically fix code analysis issues directly from your editor window. Just click the yellow lightbulb and select the auto-fix option.

  • The Code Analysis lightbulb is now much more responsive with its re-positioning when scrolling through your scripts.
  • You can now bring up the List of Code Analysis Issues using the keyboard shortcut Ctrl+Shift+Y.

Fixes

  • SP-6956 : Fixed typo in built-in method (CONCAT_WS instead of CONCAT_WD) when running PE017.
  • SP-7127 : BP003 SELECT in trigger no longer reports an issue if the SELECT statement is part of a CURSOR definition.
  • SP-7267 : Improved startup performance of SQL Prompt in Visual Studio.
  • SP-7371 : Fixed a bug where attempting to fix instances of BP006 would incorrectly insert an ORDER BY clause after a semicolon, if one was present in the query.
  • SP-7377 : Fixed a bug where attempting to fix instances of BP022 would sometimes result in an incorrect fix when used after a chunk of whitespace. 

9.4.6.7396 - December 13th 2018

Features

  • You can automatically fix BP022 issues in your script (it replaces the usage of the MONEY or SMALLMONEY datatype with the Decimal(19, 4) datatype).

  • "Check for Updates" renders as a popup in the bottom right rather than as a big modal.
    image

    • User can dismiss the popup, setting it to remind them tomorrow, in a week or skip the version entirely.

Fixes

  • SP-6956 : PE017 correctly considers the following functions as built-in system ones:

    • CONCAT

    • CONCAT_WD

    • FORMAT

    • TRANSLATE

    • TRIM

    • DATEFROMPARTS

  • SP-7366 : Fixed crash in 'Insert semicolons' that could occur when running formatting.

  • SP-7367 : Fixed issue with highlighting issues in list of issues with no script windows open sometimes throwing an error.

9.4.5.7296 - December 3rd 2018

Fixes

  • SP-7277 : Fixed an issue where the first expression in GROUPING_ID was continually qualified by Qualify Object Names.
  • SP-7365 : Fixed a bug where highlighting a code analysis issue caused SSMS/Visual Studio to hang and become unresponsive.

9.4.4.7199 - November 21st 2018

Features

  • You can now automatically fix BP006 issues in your script.

Fixes

  • SP-7258 : Made the right-click context menus consistent between SSMS and Visual Studio.

9.4.3.7121 - November 15th 2018

This is the last officially supported version of SQL Prompt Core.

Features

  • You can now automatically fix BP005 issues in your script.

Fixes

  • SP-7241 : Fixed an error in insert semicolon refactoring.

  • SP-7261 : Camel casing on built-in datatypes is now fully consistent.

9.4.2.7031 - November 7th 2018

Fixes

  • SP-7205 : Improve insert into semicolons refactorings to work better with the selection.

  • SP-7262/SP-7265 : Fix exception: "Sequence contains no elements" in refactorings.

9.4.1.6962 - November 1st 2018

Features

  • If a refactoring fails due to script parsing errors we now still attempt to perform subsequent refactorings.
  • You can now automatically fix MI005 issues in your script.

Fixes

  • SP-7211/SP-7227 : Qualify Object Names no longer removes aliases when columns are ambiguous.
  • SP-7290 : Fixed null reference crash that could happen when splitting script windows or interacting with the scrollbar.

9.4.0.6807 - October 17th 2018

Features

  • You can now automatically fix ST006 code analysis issues in your script.
    • Issues that are fixable are represented by an orange lightbulb icon in the sidebar, rather than the traditional blue one.
    • Clicking on the lightbulb will show the issue details pane, which when applicable, will contain a button labeled "Apply Fix".
    • Clicking this button will automatically fix the relevant issue in the script.
    • For more information, see here
  • Added auto completion for the following query hints:
    • KEEP UNION
    • MAX_GRANT_PERCENT
    • MIN_GRANT_PERCENT
    • NO_PERFORMANCE_SPOOL
    • QUERYTRACEON
    • SHRINKDB PLAN
  • Added auto completion for the following query USE HINTS:
    • ASSUME_MIN_SELECTIVITY_FOR_FILTER_ESTIMATES
    • DISABLE_BATCH_MODE_ADAPTIVE_JOINS
    • DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK
    • DISABLE_INTERLEAVED_EXECUTION_TVF
    • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_100
    • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_110
    • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_120
    • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_130
    • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140
    • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_150
    • QUERY_PLAN_PROFILE

Fixes

  • Fixed a UI problem in the List of Code Analysis Issues where scrollbars were not clearly visible.
  • SP-6281, SP-6919 : Formatting certain query hints such as IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX and NO_PERFORMANCE_SPOOL no longer causes a failure.
  • SP-7282 : Fixed crash that could occur when running 'Find unused variables and parameters', 'Summarize script' or 'Encapsulate as new stored procedure' with T-SQL syntax errors present.



Didn't find what you were looking for?