Saved Filters in SSMS
Within SSMS, allow for the saving of filters.
Justification:
Particularly within large databases, often there is a reoccurring need to work with just a subset of tables. Sometimes, within different contexts, the particular subset changes. Being able to easily apply commonly used filters can allow increased productivity by eliminating frictional work (e.g. scrolling and hunting). Additionally, when filters across object types can be applied, there can be a lot of power. For example, being able to filter a particular set of SQL Agent Jobs, associated tables, and procedures related to those jobs, allows a troubleshooting developer to quickly set into a focused environment and avoid disruptive busy work.
Suggested Implememation:
Under context menus that support Filter (e.g. Tables), add the following options under the Filter menu: Manage Save Filters, Save Current (if there is a filter applied), and a list of saved filters. Select the one the save filters will apply the filter. Save Current will prompt for a name and save sing that name (overwriting, if confirmed). Manage Save Filters will display a dialog that allows a save filter to be deleted, or all filters to be exported, or to import a set of save filters (overwriting, if confirmed, on a filter by filter bases).
Additionally, on the database node, add a context menu call Filter Profile. Functioning similarly to the above, it works will all the filters of all the sub-nodes within the database.