SQL Toolbelt

Uma coleção de ferramentas para comparar, sincronizar, fazer backup, analisar e muito mais para o SQL Server.

Publicado por Redgate Software
Distribuído pela ComponentSource desde 2005

Preços a partir de: $ 3,148.20 4.00 Comentário com média em estrelas4.00 Comentário com média em estrelas4.00 Comentário com média em estrelas4.00 Comentário com média em estrelas4.00 Comentário com média em estrelas (1)

Captura de tela do SQL Toolbelt
i

Please note that SQL Toolbelt is only available to customers who already own a License and need to purchase additional licenses, or renew existing subscriptions.
If you do not already own SQL Toolbelt please consider Redgate Deploy or SQL Toolbelt Essentials as an alternative.

SQL Toolbelt - Includes updates to SQL Prompt and SQL Monitor

Released: Oct 17, 2018

Atualizações na October 2018 release II

Recursos

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

Correções

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.
Back to SQL Toolbelt Releases