I'm looking for some general insight into the usefulness of Solutions and
projects in SQL Server Management Studio (thus the many related questions
below - to give you the sort of information I'm looking for).

I've been developing with SQL Server for many years and I'm finally getting
up to speed on Management Studio. I've read up on Solutions and Projects. I
know how to set them up and add connections and queries. No problem there.

My question(s): How are these solutions and projects helpful? Are any of you
more seasoned DBAs or developers actually using them?

I understand that a project shows a list of scripts (under the Queries node)
and that seems handy. But what about Connections? There's a Connections node
under which we can add one or more connections. But what does a connection
[in a project] actually DO for us? How are we supposed to use it? AFAIKT we
can only right-click it and open a new query window that is connected to the
db specified by the connection. Is that it? It it just another way to open a
new query window that is connected to a database? Am I missing something?

Thanks for your thoughts on this!

column dataType
Joining 2 select statement with like fields
Applying a function to a subquery
Query from a dynamic table
Tuning