O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Peter A. Carter 2016

Peter A. Carter, Expert Scripting and Automation for SQL Server DBAs, 10.1007/978-1-4842-1943-0_6

6. Building an Inventory Database

Peter A. Carter

(1)Botley, UK

An inventory database is critical to the success of your automation strategy. Despite being a relatively small and simple database, an inventory database will act as your hub for orchestrating your automation efforts throughout the enterprise.

Even if your company has a fully fledged CMDB, which includes databases, the astute DBA will still have his or her own inventory system. This is because a DBA will have more control over his or her own database, limiting the chances of the data becoming stale or dirty.

Having full control over the system also means that you can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required