Project Description
DBA Inventory is a SQL Server based project to help inventory, manage, control, and report on a large SQL Server infrastructure without requiring agents on the target.

With the proliferation of SQL Server databases throughout organizations, keeping track of where those databases are, what systems they reside on, who is reponsible for them, and monitoring their trends can become a nightmare. This project offers a professionally designed database along with appropriate stored procedures to record and keep this data up to date.  The design philosophy is to not require any additional objects on the target servers, instances, or databases, yet after seeding a minimum of server and instance information maintain a schuled update of databases throught the organization.

SSRS reporting is a major component of the project where by the data is exposed to a wider audience (read management) and permits quick answers to complex questions.

The project also contains a minimal amount of SSIS packages that perform the scheduled updates.

The final component is a GUI to enable what manual data entry is required and to more easily control the application as a whole.


Last edited Nov 23, 2010 at 10:48 PM by mryder66, version 3