When you have a large number of SQL Servers it becomes a no brainer to find a way to manage them effectively. SQL Server Management Studio can be very effective in managing local servers by grouping them according to your usage necessities.
Registering SQL Server instances makes it easy to administer. Connecting to servers is a lot faster if you register all the instances in the Local Group of Servers. In SQL Server Management Studio 17.7 it is lot easier to register than in previous, older versions.
I have three SQL Server instances from 3 different versions. After registering I just need to double click the server I am using and I am ready to roll.
Watch the Video:
https://youtu.be/eWkbcBgjq80
No comments:
Post a Comment