rich-ott / ssms-query-history Goto Github PK

An external UI for searching the query history should be created to allow for looking up items without first opening SSMS.

There needs to be a way to announce updates; either automatically or via some sort of notification.

Add a color bar to the query windows to quickly identify the connection that is in use. There are several requirements for this:

• This needs to be more reliable than the SSMS built-in connection coloring
• The color needs to change whenever the connection changes
• Needs to be configurable per server (preferably using regex to avoid duplicated entries)
• (optional) The tab should reflect the color as well

When searching for something, it would be great if the enter key could also run the search command, instead of having to tab onto or click on the search button.

Find a way to allow having a version installed for SSMS 2012, 2014, and 2016 side-by-side.

Create a context menu to the results view. It should include at the very least Select All and Copy options. Ideally it should include options to Copy query to current window and Copy query to new window.

An option to store query history in a database table should be created to provide more efficiency in storage and searching.

Searching for "+1" throws the following exception:

System.ArgumentException: parsing "+1" - Quantifier {x,y} following nothing.

After running several large queries, particularly on a slow disk, SSMS will start to delay while the query is persisted. Presumably this is because of the time to open/update/save the file with the new query information.

Maybe a background thread to save the query text?

It would be nice to have the ability to save and restore tab sessions.

A UI should be created that allows for changing the settings and/or options of the add-in.

Trying to copy a query with Ctrl+C displays the below error if the active query window is currently unsaved. This is an issue with SSMS (both 2012 and 2014). A current workaround is to select the query text and right-click and Copy. Or just close all open query windows/create a new query window just for the results.