If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you check this out. Earlier iterations of Red Gate's SQL Prompt did not change tab color immediately when the connection was changed. Red Gate's tab color could get out of sync occasionally, so I stopped depending on it.
Apparently this has been improved on and my testing now shows that the tab recoloring for connections is changing when the connection is updated immediately. This is a great visual indicator of what your query window is connected to.
I'm still a fan of SSMSBoost combined with SQLPrompt, but I'm finding myself needing less addins as SQLPrompt has been enhanced. The ease of configuration and setup is a major factor as well. SSMSboost Preferred connections are great for when needing to quickly context switch between different connections in the same window (and sync with object explorer)
Resulting textbox overlay
possible improvements for SQLPrompt
- I think that SQLPrompt would have some great productivity enhancements by implementing something similar to SSMSBoost preferred connections. Here is a UserVoice item on it. Add your vote
- SQLPrompt enhancements to synchronize object explorer connections based on the current query window would be another great option. I created a user voice item on this here.
Overall, I'm finding myself depending on SQLPrompt more. As a member in the Friend of Redgate program, I've had access to try some of the new beta versions and find the team extremely responsive.
Disclaimer: as a Friend of Redgate, I'm provided with app for usage, this doesn't impact my review process.
Productivity SSMS add-in packed with useful tolls: scripting, sessions, connection management. Plug-in works with SSMS 2008 and SSMS 2012 SQL Server Management Studio: SSMS add-in with useful tools for SQL Server developers
Write and format SQL with SQL Prompt's IntelliSense-style code completion, customizable code formatting, snippets, and tab history for SSMS. Try it free