I have a question that I am confused about. I am also new to database stuff as well so this question may be basic.
For example, at my work, we use SSMS to connect to our server's databases.
When connecting from SSMS, we enter in (server_name\instance). Like for example
But for some, only the server is entered and not the instance along with it. How does this work? I thought in order to connect, we always need to type an instance after the server name?
Like for example, some we need
PC100\SQLexpress in order to connect to the server's databases.
And then for others we just need to type in
PC200 to connect, and not needing to type the instance.
Can anyone explain?