SQL Toolbelt

SQL Toolbelt Updated:

SQL Compare 9.0 and SQL Data Compare 9.0 now supports SQL Azure databases.

SQL Source Control 2.1 adds support for Sourcegear Vault, Vault Pro, and additional systems (Mercurial, Perforce, CVS, Git, Bazaar and more).

SQL Backup 6.5 is a minor release that includes various engine improvements and bug fixes:

New features

• Ability to choose "existing database file location" as well as the SQL Backup suggested defaults.

Bug fixes and improvements

• Improvements to purging backup files in the following cases:
  • when folders contain spaces in the name
  • when the restored database name differs from the original database name
• Support for KEEP_CDC
• LATEST_ALL keyword fixes for restoring the latest full backup and and all subsequent log and differential backups, in particular:
  • handling large backup sets
  • handling SQB files created with earlier versions of SQL Backup
• Network resilience bug fixes
• Product activation improvements
• Improved debugging information and error handling:
  • Improved timeout for VDI functions and threaded SQL connections
  • Debug information for decompression
  • More exception handling code when writing process data for the GUI
  • When creating new folders
  • Partially created backup files when running of disk space
  • Detect if t-log backup file has previously been restored during log shipping

Miscellaneous

• Quality improvement program - users now have the option to send usage information back to Red Gate to help us improve future versions

SQL Monitor 2.2

New Features:

• Maintenance window - you can now set maintenance windows to temporarily suspend alerting during set periods.
• Four new alerts - you will now receive alerts when connection issues occur.
• Machine offline and SQL Server instance offline alerts have been renamed Machine unreachableand SQL Server instance unreachablerespectively.

Bug Fixes:

• SRP-2134: The Fragmented index alert is broken.
• SRP-2927: Alert descriptions for Backup overdue, Log backup overdue and Integrity check overdue alerts need changing.
• SRP-3135/ SRP-3136: The time displayed in the Occurrences tab of the Alert details page is out by 12 hours or is in the wrong format.
• SRP-3018: Purge behavior does not work as expected; a backlog of data due to be purged builds up, and attempts to purge the backlog affects performance. To fix this, SQL Monitor has increased its usage of tempdb, so you may see tempdb grow by up to half the size of your Data Repository database. Once the backlog of data has been purged successfully and your SQL Server service has been restarted, tempdb size will revert back to normal.
• SRP-3140: The Disk used alert description is not entirely accurate.
• SRP-3090: Offline alerts: include seconds on alert timings.
• SRP-2924: Allow a threshold of more than 100% for the Job duration unusual alert configuration.
• SRP-2202/ SRP-1769: The availability of button in the Alert Inbox should not be determined by the visible page.
• SRP-1137: Enable sorting of the SQL Process by ID to make it easier to find a particular process.
• SRP-3243: On the Alert details page, trace data is retrieved only when users click a specific SQL process.

Known Issues:

• SRP-495: If the Base Monitor loses its connection to the SQL Monitor Data Repository then you may see the following error, “System.Data.SqlClient.SqlException was thrown by method Query on service DataPresenterService: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding”.
• SRP-1443: An internal error occurs if the database name contains a non-latin character.
• SRP-2167: A user will see a “script stack space quota is exhausted” JavaScript error on Firefox when there is a lot of performance data in an alert details page. Use an alternative browser to view SQL Monitor.
• SRP-2310: “Back in time” can sometime crash with an error when using IE 7. Use an alternative browser to view SQL Monitor.
• SRP-2702: Long running query process ID not appearing in the SQL Processes/Trace tab.

Whether you are a DBA (Database Administrator) or a developer, you benefit from using tools that help you work better. The SQL Toolbelt is one of the simplest and most effective ways for you to access all the SQL Server tools that you need, to get your job done, the way you want to do it, and fast.

SQL Toolbelt Features:

• All 13 Red Gate SQL Server tools in a single installer
• Relentlessly tested for accuracy, reliability and ease of use
• Save over 70% compared with buying the tools separately

Products included in the SQL Toolbelt:

• SQL Compare Pro: compare and synchronize schemas
• SQL Data Compare Pro: compare and synchronize data
• SQL Packager: package, upgrade, and install databases
• SQL Prompt Pro: seamless IntelliSense-style code completion and layout
• SQL Data Generator: automatically populate databases with realistic test data
• SQL Dependency Tracker: graphical impact analysis
• SQL Refactor: a host of smart refactorings on the fly
• SQL Doc: multiple database documentation
• SQL Backup Pro**: compress, securely encrypt and strengthen backups - fast
• SQL Monitor**: monitors MS SQL Server health and activity, with alerts and diagnostic data
• SQL Multi Script Unlimited: execute multiple scripts against multiple SQL Servers with a single click
• SQL Comparison SDK: automate functionality with our APIs
• SQL Object Level Recovery Native: recover database objects from SQL Server backups

**SQL Backup and SQL Monitor are licensed per server. All other tools are licensed per user.

Purchasing a support contract provides you with free upgrades as well as support.

• Upgrades - For the duration of the support contract you will not need to pay for upgrades.
• Support - For the duration of the support contract, you will receive support on the use of the products by email and, if necessary, by telephone or video conference.