How can we help you today? How can we help you today?
Sarah

Activity overview

Latest activity by Sarah

Why this has been happening Due to some architectural changes to SSMS that were introduced from the v21 release onwards, we've seen a significantly higher volume of dependency changes than ever before. Because our tools run as plugins inside SSMS rather than as separate processes, every dependency update means we need to make sure our products still support it. That's made keeping pace with SSMS releases considerably more challenging than it used to be. What we've already changed, and what's next We want to be transparent that we've been actively working on this, and a number of improvements are already in place:   We've changed the default upgrade mechanism so SQL Prompt now updates the whole of SQL Toolbelt Essentials rather than individual products. A lot of the crashes were caused by one TBE product being updated while others weren't, leaving users on a mixed and unsupported set of versions, which matches what some of you found above with old or unused Redgate tools (like SQL Dependency Tracker) causing the crash. This change has meaningfully reduced the frequency of issues. We now get early access to SSMS release candidates ahead of the monthly public release, which lets us test and get fixes out before it lands for everyone. This has proven largely reliable, though it doesn't fully eliminate risk since last minute changes can still happen. We'll keep investing in this regression testing. We believe the last few SSMS releases haven't required any hotfixes on our side. If your team has kept seeing problems on the latest versions of both SSMS and SQL Toolbelt Essentials, we'd like to know, since it may point to something specific to your environment that we're not aware of. We do acknowledge the SSMS 22.6 release caught a library issue in our licensing code, which we're sorry for. That one got through our testing process. We're also looking at how to communicate compatibility better ahead of releases, including showing verified compatible SSMS minor versions on our docs site. Not in place yet, but it's something we're committed to. / comments Official comment
Why this has been happeningDue to some architectural changes to SSMS that were introduced from the v21 release onwards, we've seen a significantly higher volume of dependency changes than ever befo...
0 votes
Why this has been happening Due to some architectural changes to SSMS that were introduced from the v21 release onwards, we've seen a significantly higher volume of dependency changes than ever before. Because our tools run as plugins inside SSMS rather than as separate processes, every dependency update means we need to make sure our products still support it. That's made keeping pace with SSMS releases considerably more challenging than it used to be. What we've already changed, and what's next We want to be transparent that we've been actively working on this, and a number of improvements are already in place:   We've changed the default upgrade mechanism so SQL Prompt now updates the whole of SQL Toolbelt Essentials rather than individual products. A lot of the crashes were caused by one TBE product being updated while others weren't, leaving users on a mixed and unsupported set of versions, which matches what some of you found above with old or unused Redgate tools (like SQL Dependency Tracker) causing the crash. This change has meaningfully reduced the frequency of issues. We now get early access to SSMS release candidates ahead of the monthly public release, which lets us test and get fixes out before it lands for everyone. This has proven largely reliable, though it doesn't fully eliminate risk since last minute changes can still happen. We'll keep investing in this regression testing. We believe the last few SSMS releases haven't required any hotfixes on our side. If your team has kept seeing problems on the latest versions of both SSMS and SQL Toolbelt Essentials, we'd like to know, since it may point to something specific to your environment that we're not aware of. We do acknowledge the SSMS 22.6 release caught a library issue in our licensing code, which we're sorry for. That one got through our testing process. We're also looking at how to communicate compatibility better ahead of releases, including showing verified compatible SSMS minor versions on our docs site. Not in place yet, but it's something we're committed to. / comments Official comment
Why this has been happeningDue to some architectural changes to SSMS that were introduced from the v21 release onwards, we've seen a significantly higher volume of dependency changes than ever befo...
0 votes
Getting started with the Redgate community forums
This article will help you get started, guiding you through the process of registering, navigating and posting.Registration and loginYou can sign into the forums using your Redgate ID, for more inf...
Edited 1 follower 0 comments 0 votes
Entra ID MFA Authentication
SQL Prompt now uses a dedicated Microsoft Entra ID application to authenticate users to Azure SQL Database instances.The permissions requested are limited to those required to access the database a...
Edited 2 followers 0 comments -4 votes
How to Get Started with the Redgate Product Support Community Forums
Welcome to the Redgate Community Forums! We’re thrilled to have you here. This space is for you: to help you achieve success with your Redgate tools and connect you with fellow users and members of...
14 followers 1 comment 1 vote
SSMS Tab Management
SQL Prompt's Tab History keeps a history of the query windows (tabs) that you open in SSMS, and saves their contents in response to certain actions. You can use it to track down scripts that you fo...
1 follower 0 comments 0 votes
SQL Code Snippets
A snippet is any pre-defined block of code, which you can insert into a query pane at the current cursor position, or around currently selected SQL text. SQL Prompt comes with many pre-defined snip...
Edited 1 follower 0 comments 0 votes
SQL Code Formatting and Styles
Formatting and styles are all about taking some code and making sure that it is easy to read and understand. Formatting or style changes are 'decorative' changes that affect only whitespace, such a...
1 follower 0 comments -2 votes
SQL Code Completion and IntelliSense
SQL Prompt offers as-you-type IntelliSense and code completion suggestions, as well as providing other information, and helping you navigate around your code. As you accept and insert the suggested...
Edited 2 followers 1 comment -1 votes
Installing and running SQL Prompt
To install SQL Prompt, you must have administrator privileges. If you're upgrading from a previous version, the installer does all the preparation for you.Installing SQL PromptWhen you run the SQL ...
Edited 2 followers 0 comments -8 votes