7 Inventorying your SQL estate
In the previous chapter, you learned how to find all of the SQL Server instances on your network. Now it’s time to gather essential information about each of those servers and create an inventory of it.
Creating inventories lets you provide access to reports for members of the organization without having to grant access to your SQL instances. Keeping your inventory up to date will help to speed up the planning of migrations and upgrades in particular, because knowing what features are in use can keep upgrades properly planned and on track.
DBAs are often expected to just know the configuration of every host, instance, and database in their estate. If you have only a handful of instances, this may be possible, but ...
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.
