I work on a server over a VPN that has about 50 databases, some of which have many tables and stored procedures. I only want to work in 2-3 of these databases. Loading this server takes more than 10 minutes, completely freezing SSMS. Sometime SHD glitches and doesn't load correctly.
As a proof-of-concept, I'm envisioning a list where each member contains a server name regex and a database name regex. If the server regex matches, load only those databases matched by the database regex. If this is useful, it could be extended to include another regex for schema name.
I work on a server over a VPN that has about 50 databases, some of which have many tables and stored procedures. I only want to work in 2-3 of these databases. Loading this server takes more than 10 minutes, completely freezing SSMS. Sometime SHD glitches and doesn't load correctly.
As a proof-of-concept, I'm envisioning a list where each member contains a server name regex and a database name regex. If the server regex matches, load only those databases matched by the database regex. If this is useful, it could be extended to include another regex for schema name.