Released: Jul 2, 2018

Atualizações na July 2018 release

Recursos

SQL Toolbelt includes the following updates:

SQL Backup Pro v9.2.5

• The configuration of reports can now be persisted.
• Telemetry has been updated in accordance with the privacy policy.

SQL Compare Pro v13.4

• Adds an "Ignore Change Tracking" option
• The "Ignore authorization on schema objects" option now also includes schemas themselves.

SQL Data Compare Pro v13.4

• Compatibility with SQL Compare 13.4.1.6601.

SQL Data Generator v4.0.6

• Allow the Credit Card Number generator for bigint columns.

SQK Dependency Tracker v3.0.7

• Includes bulk uninstaller for all Toolbelt products.

SQL Monitor 8.0.9

• Disk capacity planning (preview) - see historic, current, and projected disk usage across your estate.
• Installed Versions now shows the latest available Service Packs and Cumulative Updates for your estate.
• Differential backup overdue alert.
• Failed job report tile.
• Alert types for high resource utilization on Azure SQL DB databases.
• Test button on monitored entities configuration page for Azure SQL DB.
• New data purge category has been added for storage data (e.g. Disk Capacity and Data File Size), allowing for data needed for usage projections to be stored for longer.
• Performance of the server overview page has been improved when the server has a large number of disks.
• The alert inbox now shows the duration of alerts when hovering over 'Last Updated' values.
• Added new logon failures summary report tile.
• Information on space usage on the Data purging configuration page.
• Suspended instances now appear on the global dashboard.
• Added option to increase number of queries viewed in top queries table.
• Added a .xdl download for deadlocks when using extended events.
• Added wait time and wait resource when viewing a blocking session tree.
• Improved behavior of links throughout the application to allow use of browser features such as open in a new tab, or copy link address.

SQL Multi Script v1.4.1

• Option to let each script run in its own connection. This prevents scripts that set server-level parameters (eg SET ROWCOUNT = 1) from causing side effects in later scripts.
• SQL Multi Script is now available as part of SQL Toolbelt Essentials.

SQL Prompt Pro v9.2

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

Correções

SQL Toolbelt includes the following fixes:

SQL Backup Pro v9.2.5

• Queries run via SQBDATA that don't return a resultset do not now error.
• SQL Compact queries returning boolean fields now return results.
• Fixed error on persisting activity history when locale has commas as decimal separator.
• The installer no longer prevents installing on operating systems older than Windows Server 2008 R2.
• VDITimeout setting on command line is respected.
• Upgrade SQL Server Compact libraries from 3.5 to 4.
• Prevent two simultaneous backups using the same file name.
• Added more information to the output of RESTORE HEADERONLY.
• UI warning messages for Azure Managed Instances (which Redgate can't support).
• Made textbox taller to accommodate font issues on older Windows versions.
• Documentation link fixed.
• Reduce amount of work done on remote servers when pulling backup history.
• Bulk uninstaller updates.
• Release notes URL in product fixed.
• Corrected layout issues in the server options dialog.

SQL Compare Pro v13.4

• SQL Compare no longer creates SET statements in the context of creating a scripts folder, when filtered indexes are included.
• Parse error on AT TIME ZONE with bracketed string literal fixed.
• Deploying a varchar(4096) column or wider onto a varchar(MAX) no longer gives spurious warning about truncation. Deploying in the other direction gives the correct warning.
• Contracts and services with out of database / default / built-in message types and contracts, and some full text catalogs, no longer cause an exception when they exist in the target.
• Fixed issue parsing AT TIME ZONE where the time zone is the result of a nested SELECT statement.
• Deploying column changes to a fulltext index in a scripts folder will no longer create duplicate ALTER FULLTEXT INDEX statements.
• Modifying a key index of a fulltext index will now drop the fulltext index before and recreate it later.
• Changing the XML schema collection on a column will provide a more suitable warning.
• The interactive HTML report no longer sees case differences in data types as a difference.
• Copying text from the SQL differences pane to the clipboard now preserves line endings.

SQL Data Compare Pro v13.4

• If "WHERE" is included in a where clause, it no longer causes a broken update script.
• Dropping an index linked via a foreign key to a table that is not selected for deployment will now ensure the foreign key dependency is respected.

SQL Data Generator v4.0.6

• Telemetry has been updated in accordance with the privacy policy.
• Now respects the value of the "Trust server certificate" checkbox in SSMS.
• Various SSMS integration fixes.
• Fix for an installer bug.
• "Use existing data source" now passes through datetimeoffset column values.
• Improve help text describing options of the Foreign Key generator.
• Fixed crash if product is installed to, or started from, top level directory in file system.
• The command line executable now displays the correct major version number in its file description.
• Bulk uninstaller improvements.

SQL Dependency Tracker v3.0.7

• Telemetry has been updated in accordance with the privacy policy.
• Now respects the value of the "Trust server certificate" checkbox in SSMS.
• Various SSMS integration fixes.
• SSMS menu item no longer fails to load in certain circumstances.
• Fix for an installer bug.
• Fix problem where unable to load project file, relevant to case-sensitive databases.
• Bulk uninstaller improvements.
• Intermittent connection issue with licensing function fixed.

SQL Doc v4.0.11

• Telemetry has been updated in accordance with the privacy policy.
• Now respects the value of the "Trust server certificate" checkbox in SSMS.
• Various SSMS integration fixes.
• Bulk uninstall improvements.
• Intermittent licensing connection problems fixed.

SQL Monitor 8.0.9

• The VMWare hosts configuration page now shows the configured VMWare hosts correctly.
• Improved the configuration page when working with Azure SQL DB servers and databases.
• Fixed an issue where Azure SQL DB servers may momentarily show as connected before failing.
• Prevent Unknown values appearing in some long running query and blocked process alerts when using a low alert threshold.
• Schema update - The schema upgrade may take a few minutes due to population of the Alert GroupCIR column. This change significantly improves the performance of the Grouped Inbox.
• Telemetry has been updated in accordance with the privacy policy.
• Fixes to Active Directory authentication.
• This release contains a number of bug fixes for various issues reported to support.
• Fixed an incorrect warning when alerting on database file usage for filestream files.
• Improved memory consumption of the server overview page when run for extended periods of time with auto-refresh enabled.
• Auto-refresh on the server overview correctly persists page reloads.
• Server overview page correctly respects the time period when provided as a URL parameter.
• Fixed an issue where database file usage alerts may not be raised or be configurable.

SQL Multi Script v1.4.1

• Telemetry has been updated in accordance with the privacy policy.

SQL Prompt Pro v9.2

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