8 Registered Servers
Our favorite way to organize servers within a SQL Server estate is by using Registered Servers (http://dbatools.io/registerservers), which is an instance inventory system introduced in SQL Server 2005. Registered Servers is our preferred inventory system because it has all of the basic features we need, such as grouping, authentication, and aliases, and it’s included in SQL Server at no additional cost. This means we don’t have to procure an inventory system each time we begin working in a new environment.
Registered Servers supports SQL Server 2000 instances and later and can support the Database Engine, Analysis Services, Integration Services, and Reporting Services. We prefer to use this feature as a simplified inventory ...
Get Learn dbatools in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
