The Basics of SSMS and Its Features
Learn about the basics of SSMS and its features.
Managing connections
There are several ways to manage connections to servers within SSMS. The connection near the top arrow allows managing connections to database servers within the current query. The connection near the bottom arrow will enable us to manage connections to many database servers in SSMS.
Choosing the database
Within SSMS, we can choose the databases we prefer to use, depending on which database server we connect to. All we have to do is click the “Databases” and click the desired database from the drop-down list.
New query window
To run queries against the database, we must open a query session. There are a few ways of doing this. One is to click the “New Query” button as shown below to open a query to the current database connection. We can also see that the shortcut is “Ctrl + N.”
The second way to do this is by using the “Object Explorer” window and finding the database we want to use. ...