New to the database side of IT and I have a few questions...
I'm trying to figure out what servers and databases I can access through SSMS.
What is the best practice for installing/using SQL Server Management Studio? Should I install it on my laptop, then connect to servers remotely? Or install it on one of our SQL Servers and access with a remote desktop connection to that server from my laptop?
Also, do all servers have databases that can be accessed or do they have to be "SQL Servers"?
Thank you for replies in advance!