SQL Toolbelt - Includes updates to SQL Prompt 9.4 and SQL Monitor 8.0.20

SQL Monitor includes new Backup and SQL Agent Job pages added to estate tab.
October 25, 2018
New Version

Features

Updates in SQL Monitor 8.0.20

  • Preview - New Backup and SQL Agent Job pages have been added to the estate tab.
  • Installed versions now shows GDRs as well as CUs and SPs.

Updates in SQL Prompt 9.4

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

Fixes in SQL Monitor 8.0.20

  • Database File Usage alert for Filestreams has been fixed so that it only raises alerts if a max size is set.
  • Excluded master database from Differential Backup Alerter, since Differential Backup cannot be performed on master.

Fixes in SQL Prompt 9.4

  • Fixed a UI problem in the List of Code Analysis Issues where scrollbars were not clearly visible.
  • Formatting certain query hints such as IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX and NO_PERFORMANCE_SPOOL no longer causes a failure.
  • 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.
SQL Toolbelt - Includes updates to SQL Prompt 9.4 and SQL Monitor 8.0.20
SQL Toolbelt

SQL Toolbelt

A collection of tools to compare, synchronize, backup, analyze and more for SQL Server.

Get Quote Buy Now

Got a Question?

Live Chat with our Redgate Software licensing specialists now.