Lanzamientos de SQL Prompt Pro

Released: Mar 6, 2019

Actualizaciones en 9.4.12

Características

  • The Check for Updates popup now shows both the latest available version and your currently installed version.

Correcciones

  • Fixed a bug where attempting to insert semicolons on scripts containing ALTER EVENT SESSION START/STOP statements would sometimes result in incorrect semicolon placement.
  • Fixed a bug where attempting to autofix some scripts would throw an error.
  • Fixed a bug where InsertSemicolons refactoring would insert semicolons after GO command followed by a WITH clause.

Released: Feb 14, 2019

Actualizaciones en 9.4.10

Características

  • Based on customer feedback, the SQL Prompt experimental features are not going to be deprecated yet.
  • The suggestions pop-up can be made transparent by holding down the Ctrl key, allowing you to see what is behind it.
  • The keyboard shortcut to open code analysis issues has been changed to Ctrl+Shift+E.

Correcciones

  • BP014 no longer reports an issue with columns that don't declare NULL/NOT NULL if that column is a primary key.
  • Qualify Object Names no longer tries to qualify column...

Released: Jan 9, 2019

Actualizaciones en 9.4.7

Características

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

Correcciones

  • SP-6956 : Fixed typo in built-in method (CONCAT_WS instead of CONCAT_WD) when running PE...

Released: Dec 13, 2018

Actualizaciones en 9.4.6

Características

  • 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.
    • User can dismiss the popup, setting it to remind them tomorrow, in a week or skip the version entirely.

Correcciones

  • SP-6956 : PE017 correctly considers the following functions as built-in system ones:
    • CONCAT
    • CONCAT_WD
    • FORMAT
    • TRANSLATE
    • TRIM...

Released: Oct 17, 2018

Actualizaciones en 9.4

Características

  • 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.
  • Added auto completion for the following query hints:
    • KEEP UNION
    • MAX_GRANT_PERCENT
    • MIN...

Released: Sep 26, 2018

Actualizaciones en 9.3

Características

  • You can now refactor INSERT statements into UPDATE statements, making it easier to update the data in your tables.
    • This can be triggered by either right clicking in the script window and selecting the command, or by using the keyboard shortcut Ctrl+B, Ctrl+P.
    • The refactoring automatically adds a default WHERE clause, which you can customize to suit your needs.
  • You can now go directly to the Product Learning section of the Redgate Hub from within SQL Prompt.
    • Click SQL Prompt &gt...

Released: Jun 27, 2018

Actualizaciones en 9.2

Características

  • In addition to "as you type" code analysis, you can now also display a dockable list of all the issues in your currently selected script window.
    This is accessible via the Prompt menu: 'Show List of Code Analysis Issues'.
  • Improved performance of background code analysis.

Correcciones

  • Collapsed alignment layout options could cause formatting to fail when dealing with optional parentheses.

Released: Feb 21, 2018

Actualizaciones en 9.1

Características

  • Code analysis settings can now be saved to individual files (.casettings) and shared amongst your team.

Correcciones

  • Fixed - Missing space before NOT after IF RIGHT(...).
  • Fixed - Cannot insert semicolons for DBCC statements.
  • Fixed- Exception when closing editor window after using snippets.
  • Fixed - STRING_AGG intellisense.

Released: Jan 31, 2018

Actualizaciones en 9.0.8

Características

  • Code analysis now supports larger scripts without freezing the SSMS/VS UI.
    • Limitation: Only the first 50,000 issues of code analysis are shown.

Correcciones

  • Do not show ST010 issue for CTE.
  • PE010 shouldn't be triggered on a SELECT INTO statement.
  • Don't detect BP014 issue on computed non persisted columns.
  • BP014 Shouldn't apply to identity columns.
  • "Place expressions on new line" under THEN expressions moves ELSE expression.

Released: Dec 11, 2017

Actualizaciones en 9

Características

New code analysis provides fast and comprehensive analysis of T-SQL code in SSMS and Visual Studio.

  • Discover over 80 code issues and hidden pitfalls as-you-type.
  • Get clear explanations and suggestions to improve your code.
  • Choose from a large selection of analysis rules and manage which ones are displayed.