SQL Toolbelt - Incluye actualizaciones para SQL Prompt 9.4 y SQL Monitor 8.0.20

SQL Monitor incluye nuevas páginas Backup y SQL Agent Job añadidas a la pestaña Estate.
Octubre 25, 2018
Nueva versión

Características

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

Correcciones

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 - Incluye actualizaciones para SQL Prompt 9.4 y SQL Monitor 8.0.20
SQL Toolbelt

SQL Toolbelt

Una colección de herramientas para comparar, sincronizar, crear copias de seguridad, analizar, etc. para SQL Server.

Solicitar presupuesto Comprar ahora

¿Alguna pregunta?

Chatee en vivo ahora mismo con nuestros especialistas en licencias de Redgate Software.