User profile for chris.whitworth

Hi krm; Unfortunately, it is not technically possible to bring SIPFramework support to SSMS2016. In changing to the VS2015 shell for SSMS, Microsoft have switched from the old addin format to the new .vsix extension format as used by Visual Studio; one side effect of this change is that integration points such as buttons, commands, toolbars and menu entries have to be statically declared up-front. As it is not possible to dynamically create these, SIPFramework cannot function as it currently does in pre-2016 versions of SSMS. We are still working on a strategy for supporting developers using SIPFramework to build their addins for SSMS2016 - we have an internal technical solution to make migration to the new extension format more straightforward, but as the sands are still shifting at Microsoft's end, we don't want to commit to anything until we know exactly where we stand - for example, if Microsoft decide to build an SSMS extension gallery similar to the existing Visual Studio gallery, we would probably encourage people to move to that. Regards; Chris / comments

Hi krm; Unfortunately, it is not technically possible to bring SIPFramework support to SSMS2016. In changing to the VS2015 shell for SSMS, Microsoft have switched from the old addin format to the n...

0 votes

There is now an updated version of this beta (2.3.0.275) available. The changes are internal but should help interoperability with future SSMS releases and other Redgate products. You should uninstall the previous beta before installing this version. Download here / comments

There is now an updated version of this beta (2.3.0.275) available. The changes are internal but should help interoperability with future SSMS releases and other Redgate products. You should uninst...

0 votes

Hi; There are no plans at the moment for a Visual Studio version of SQL Search; however, it doesn't feel like it should be too hard to get a version running, given the fact the new SSMS is built on the VS2015 shell. If other people are interested in this, please let us know and I'll add it to our backlog for consideration. Regards; Chris / comments

Hi; There are no plans at the moment for a Visual Studio version of SQL Search; however, it doesn't feel like it should be too hard to get a version running, given the fact the new SSMS is built on...

0 votes

There is now also a beta of SQL Search 2.3 also including support for SSMS March 2016 Preview Refresh, which you can download from the forum post here. / comments

There is now also a beta of SQL Search 2.3 also including support for SSMS March 2016 Preview Refresh, which you can download from the forum post here.

0 votes

Hi; I'm sorry you're seeing this problem - it's not something we've seen internally, so I've filed a bug report (SDI-687) indicating that under some circumstances it appears to consume more memory than expected and crash out Management Studio. As we've not seen this happen internally it would help if we had a little more detail to narrow down what we're looking for - in particular, do the databases you are searching contain a very large number of objects, or any programmable objects (stored procedures, functions, etc) with an unusually large amount of code in them? Regards Chris / comments

Hi; I'm sorry you're seeing this problem - it's not something we've seen internally, so I've filed a bug report (SDI-687) indicating that under some circumstances it appears to consume more memory ...

0 votes

Hi; My apologies about that - the release notes didn't get uploaded with the 2.2 release; I'll get that sorted out. The main things are: * Support for SQL Server Management Studio 2016 CTP3 * Support for connecting to and searching Azure SQL Databases * Auto-complete in the search text box * Respects the RGTEMP environment variable - set this to change where the index caches and log files get stored * Some minor stability fixes Installed versions will update automatically to 2.2, but to use SQL Search in Management Studio 2016 CTP3 you will need to download the full installer from the website. Thanks; Chris / comments

Hi; My apologies about that - the release notes didn't get uploaded with the 2.2 release; I'll get that sorted out. The main things are: * Support for SQL Server Management Studio 2016 CTP3 * Suppo...

0 votes

Just to update you all on this issue: I've taken a look at this issue and believe I have a fix for it. We still need to do a bit more testing, but hopefully we should be able to push the fix live sooner rather than later. Regards; Chris / comments

Just to update you all on this issue: I've taken a look at this issue and believe I have a fix for it. We still need to do a bit more testing, but hopefully we should be able to push the fix live s...

0 votes

This fix should now be live in build 2.0.1.36 - SQL Search should auto-update itself so you shouldn't need to do anything* to get the new version. *actually - it only checks for updates the first time the tab is opened, and then only installs updates the next time SQL Server Management Studio is restarted, so you may need to restart SSMS, open SQL Search, then close and re-start SSMS to get the update - a bit annoying, I know / comments

This fix should now be live in build 2.0.1.36 - SQL Search should auto-update itself so you shouldn't need to do anything* to get the new version. *actually - it only checks for updates the first t...

0 votes

Hi Paule123; I'm a developer on the SQL Backup UI; thanks for leaving feedback. We're aware that a number of users of the UI have seen performance issues in areas particularly relating to activity history; we've done some investigation work, but unfortunately, these issues are proving hard to replicate in an artificial test environment, and my suspicion is that many of them are down to a combination of the UI's update mechanism, quantity of data and the environment in which both the UI and server is running. The work is ongoing, however, and it would really help if you could answer a couple of questions - feel free to send me a private message or email me at chris.whitworth@red-gate.com if you'd rather not answer these publicly. 1) Could you describe your setup? (SQL Server version, CPU, memory, disc space, number of DBs, backup frequency, etc). In particular, how my entries in the activity history (approximately) would you say there are, and how many new entries per day are added? 2) How often would you typically launch the UI? And does the problem occur every single time you launch the UI, or only if it hasn't been run for a while? 2a) In particular, after you left the UI running over dinner, did the same problem recur the next time you opened the UI, or was it more responsive on subsequent occasions? 3) Do you run the UI on the same machine as the SQL Server instance, or on a different machine? 4) If they're running on the same machine, is the user profile (in particular, the AppData directory) of the user running the UI stored on the same storage device as the SQL Server database files or SQL Server instance? 5) Is/are your SQL Server(s) particularly heavily loaded, either in terms of CPU or IO? (or would they typically be so when running the UI?) Thanks very much; Chris / comments

Hi Paule123; I'm a developer on the SQL Backup UI; thanks for leaving feedback. We're aware that a number of users of the UI have seen performance issues in areas particularly relating to activity ...

0 votes

Hi; We're certainly aware of this bug - it hasn't been fixed in the public EAP versions yet, but the intention is that it will be. For now, there is a KB article that might help: Changing the default data location used by SQL Backup. Thanks. / comments

Hi; We're certainly aware of this bug - it hasn't been fixed in the public EAP versions yet, but the intention is that it will be. For now, there is a KB article that might help: Changing the defau...

0 votes

How can we help you today?

chris.whitworth

Comments