sql - SQL Toolbelt

  1. SQL Toolbelt- Includes updates to SQL Backup Pro, SQL Compare and SQL Data Compare.

    Release Notes: Includes new option to ignore sensitivity classifications on fields in SQL Compare, plus job filtering improvements in SQL Backup. Updates in SQL Compare 13.6.14 Adds a new option to ignore ... sensitivity classifications on fields. Additional logging of.NET assembly loading to help investigate SDC-2906. Updates in SQL Data Compare 13.6.14 Additional logging of.NET assembly loading to help investigate ... SDC-2906. Updates in SQL Backup 10.0.4 Server Options now includes an option to filter the Jobs display by job description (including wildcards). Fixes in SQL Compare 13.6.14 SC-10397: SQL Compare now sets ...

  2. SQL Toolbelt- includes new features for SQL Doc and SQL Prompt

    Release Notes: SQL Doc UI now runs as a 64 bit process, plus SQL Prompt promotes recently used suggestions to top of suggestions list. New in SQL Doc 5.0.0 The UI now runs as a 64 bit process. *As of version ... 5.0.0, SQL Doc no longer supports 32-bit versions of Windows or SQL Server 2005. New in SQL Prompt 9.5.3 Now promotes recently used suggestions to the top of the suggestions box. This feature is enabled ... it when SQL Prompt informs that there is a new version available. Fixes in SQL Monitor 9.0.12 Restore base monitor version incorrect page. SRP-11674 Report SQL Command for all blocking processes even ...

  3. SQL Toolbelt- Includes updates to SQL Monitor, SQL Prompt.

    Release Notes: SQL Monitor adds ability to send emails by alert severity, SQL Prompt adds 'Show all issues` link to autofix popup window. SQL Monitor 9.0.10 New global options to allow sending emails by alert ... severity- e.g. Medium and High only. SQL Prompt 9.5.2 Added a `Show all issues` link to the autofix popup window. Fixed in SQL Prompt Pro 9.5.2 Fixed an issue which was preventing SQL Prompt from launching ... the `Smart Rename`, `Encapsulate Object as Stored Procedure` and `Split Table` features to not work for some users. Fixed in SQL Dependency Tracker v3.1.6 Updated to the latest SQL Compare Engine, version ...

  4. SQL Toolbelt- Includes SQL Backup Pro v10 and SQL Monitor v8.0.24.

    Release Notes: Supports cloud storage for SQL backups, plus custom metrics can now be run against Azure SQL databases. Updates in Redgate SQL Backup Pro v10.0.0 Allows backups to be sent to cloud storage- Azure. ... Allows backups to be sent to cloud storage- generic S3-compatible providers. Updates in Redgate SQL Monitor v8.0.24 Show query plan from Blocking processes tree. The query plan can now be viewed from ... within the Server Overview Blocking Processes tree. Custom metrics can now be run against Azure SQL databases. Fixes in Redgate SQL Backup Pro v10.0.0 SB-5906 Licensing issue for new installs fixed. ...

  5. SQL Toolbelt- Includes updates to SQL Prompt and SQL Monitor

    Release Notes: SQL Monitor includes new Backup and SQL Agent Job pages added to estate tab. 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 ... QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140 QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_150 QUERY_PLAN_PROFILE 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. ...

  6. SQL Toolbelt- Includes SQL Prompt Pro 10.1.x

    Release Notes: SQL Prompt adds the ability to autofix issues using the Alt + Enter keyboard shortcut. Added the ability to autofix issues using the Alt + Enter keyboard shortcut. SP-7984: SQL Prompt no longer ... reports code analysis issues when using built-in HierarchyID functions. SP-7986: SQL Prompt no longer adds square brackets around SET params in ADD TARGET statements. ...

  7. SQL Toolbelt- Includes SQL Change Automation v4.1

    Release Notes: Now allows users to develop static data changes from SQL Server Management Studio. Updates in SQL Change Automation 4.1 New Features SQL Change Automation in SSMS now supports configuring ... and generating migrations for static data. Added support for SQL Compare option IgnoreDynamicDataMasking via configuration SyncOptionIgnoreDynamicDataMasking in project file. Added the ability to use a SQL Source ... Control project as a development source. SQL Change Automation will compare the contents of your SQL Change Automation project against the SQL Source Control project in order to generate new migration ...

  8. SQL Toolbelt- Includes SQL Change Automation v4.0

    Release Notes: Updates in SQL Change Automation v4.0 New in SQL Change Automation v4.0 Create and manage migration scripts in SQL Server Management Studio. This allows teams to collaborate across Visual Studio ... and SSMS, and allows developers to work in their IDE of choice. Visual Studio extension improvements- The Open in SSMS button will now detect SSMS 18. SSMS fixes- Updated SQL Compare Engine to 13.8.0.12547. ...

  9. SQL Toolbelt- Includes updates for SQL Monitor

    Release Notes: SQL Monitor adds ability to discover privileged SQL permissions on your Server Overview. Updates in June 2019 VII Release New in SQL Monitor 9.0.16 New- Discover privileged SQL permissions on your ... Server Overview- See who has sysadmin and other privileged access as well as Active Directory mappings. Fixed- SRP-11899 Increase reliability of ""Add SQL Server"" test button. Fixed- ... SRP-12025 Error when loading top queries on server overview page when more than one query has the same SQL handle. ...

  10. SQL Toolbelt- includes updates for SQL Monitor

    Release Notes: Improves configuring alerts via powershell, plus API now allows enabling or disabling alerts at the database level. New features in SQL Monitor 9.0.14 The API for configuring alerts via powershell ... is now multiple base monitor aware. The API now allows enabling or disabling alerts at the database level. Fixes in SQL Monitor 9.0.14 SRP-11947- Allow bypassing SSL authentication when generating report ... PDFs for e-mail. Fixes in SQL Source Control 7.0.25 Updates SQL Compare and SQL Data Compare to 13.7.15.11157. Fixes in SQL Test 3.1.4 SQT-628: SQL Test no longer continues to use significant CPU once ...

  11. SQL Toolbelt- Includes SQL Prompt Pro 9.5.0

    Release Notes: SQL Prompt adds support for Microsoft SQL Server Management Studio 18 and Visual Studio 2019. New in SQL Prompt Pro v9.5.0 Adds support for SQL Server Management Studio 18. Adds support for Visual ... Studio 2019. Now requires.Net Framework 4.7.2 or later. Fixes in SQL Prompt Pro v9.5.0 SP-7522: Fixed an issue of incorrect wildcard expansion from a nested SELECT containing CASE. SP-7545: Fixed an issue ...

  12. SQL Toolbelt- Includes SQL Backup Pro 10.0.3

    Release Notes: SQL Backup Pro adds support for Amazon Glacier storage. Updates in SQL Backup Pro v10.0.3 Adds support for Amazon Glacier storage. ...

  13. SQL Toolbelt- Includes SQL Source Control v7.0.0

    Release Notes: Introduces Pre and Post-Deployment scripts, support for SSMS 18, plus the ability to push to TFS Git. Updates in Redgate SQL Source Control v7.0.0 Support for pushing to TFS Git. Support for SSMS ... 18. Introduces Pre and Post-Deployment scripts. Pre and Post-Deployment scripts contain SQL that is run during a deployment of a SQL Source Control project. Provides more control over your database ... deployments. Fixes in Redgate SQL Source Control v7.0.0 Various git fixes. Pre and Post Deployment in SQL Source Control. ...

  14. SQL Toolbelt- Includes SQL Prompt Pro 9.4.6

    Release Notes: Automatically fix BP022 issues in your script (it replaces the usage of the MONEY or SMALLMONEY datatype with the Decimal(19, 4) datatype). Updates in SQL Prompt v9.4.6 You can automatically fix ... modal. User can dismiss the popup, setting it to remind them tomorrow, in a week or skip the version entirely. Fixes in SQL Prompt v9.4.6 SP-6956: PE017 correctly considers the following functions ...

  15. SQL Toolbelt- Includes updates to SQL Prompt

    Release Notes: Now allows refactoring INSERT statements into UPDATE statements, making it easier to update data in your tables. New in SQL Prompt v9.3 You can now refactor INSERT statements into UPDATE statements, ... The refactoring automatically adds a default WHERE clause, which you can customize to suit your needs. You can now go directly to the Product Learning section of the Redgate Hub from within SQL Prompt. Click SQL ... Prompt > Help > Product Learning to find how-to guides, in-depth technical articles and videos to help you uncover 'hidden gems' and make the most out of SQL Prompt. SQL Prompt ...

  16. SQL Prompt v9.1 updated in SQL Toolbelt

    Release Notes: SQL Prompt code analysis settings can now be saved to individual files and shared amongst teams. SQL Toolbelt includes the following updates: SQL Prompt Pro v9.1 Code analysis settings can now ... be saved to individual files (.casettings) and shared amongst your team. SQL Toolbelt includes the following fixes: SQL Prompt Pro v9.1 Fixed- Missing space before NOT after IF RIGHT(...). Fixed- Cannot ... insert semicolons for DBCC statements. Fixed- Exception when closing editor window after using snippets. Fixed- STRING_AGG intellisense. SQL Prompt code analysis settings ...

  17. SQL Monitor 8.0 updated in SQL Toolbelt

    Release Notes: SQL Monitor adds distributed monitoring, database file growth alerts and query history graph, and improves alert management. SQL Toolbelt includes the following updates: SQL Monitor 8.0 Grouped ... or networks that run separately within one place, without the need to install separate dashboards. Monitor all of your locations accurately from one SQL Monitor dashboard without bandwidth or security being ... Automation. A bulk importer and import API, to give you a quicker and easier way to add new servers. SQL Monitor distributed monitoring. ...

  18. SQL Toolbelt includes SQL Backup Pro 9

    Release Notes: Adds support for copying SQL Backups to Amazon AWS S3 Bucket. Updates in SQL Backup Pro 9.0.3 Support for copying SQL Backups to Amazon AWS S3 Bucket. Support to allow sqbdir to work using ... to C:\ProgramData\Red Gate\Logs\SQL Backup 9. SqbHostedStorageClient now runs under either.NET 3.5 or.NET 4. SB-4656 Log Shipping dialog page (get backup folder) fails because have not connected to Server yet. SB-5360 ... occasional problems with SQLite and journalling. SQL Backup Pro included in SQL Toolbelt. ...

  19. SQL Compare Pro and SQL Data Compare Pro 12.0

    Release Notes: Includes brand new user interfaces, support for SQL Server 2016, and over 200 bug fixes and improvements. Updates in SQL Compare 12.0 New User Interface (UI)- Overhauled UI of SQL Compare aligns ... with Redgate's new common design guidelines. Improves the underlying codebase and fixes over 200 UI related bugs. Parallel registration- When registering from a live database, scripts folder, or a snapshot, SQL ... licensing- SQL Compare now asks you to sign in when you launch the program. The new user account licensing makes it much easier for you to keep track of the tools you own and to move them between different ...

  20. SQL Data Compare 11.6 updated in SQL Toolbelt

    Release Notes: Now connects to SQL Server 2016. Updates in SQL Data Compare 11.6 Features: SQL Data Compare now connects to SQL Server 2016 release candidates and RTM. New product switcher- accessible from ... the product logo top-left. Compatibility with SQL Compare 11.6. Fixes: SC-8313: SQL Compare no longer fails to register Azure v12 databases that have been upgraded around 25th February 2016. SDC-1356: Fixes ... a crash related to extremely large deployment scripts. SDC-1418: SQL Data Compare no longer fails to compare some 100 collations when on an ntext field. SDC-1816: no longer crashes on startup if your MSI ...