Project Description
The Central Database Administration project is a combination of a management database for all SQL instances and a central data warehouse for management and monitoring. It uses as much built-in functionality as possible - such as MSX, SSRS, SSIS, etc. Automate
at least 1 FTE.
Over the last few years the number of SQL Server instances that I've worked with have only increased, and staffing - well staffing doesn't ever increase; does it? So we do as all "lazy DBAs" do - automate as much of our work as we can. Automate so much that
the system does everything that you currently do so you have time to learn how to do better things. And then automate that to learn better things. And of course, don't forget to give the pretty visuals to show your bosses how hard you are working.
The goal of this project is to share as much as possible in a single location in an effort to help other DBAs out there if at all possible. And hopefully in return, if this project helps you any, you will be able to return the favor and help to expand
on how much automation this project can do for all of us "lazy DBAs" out here.
Desires from this project:
1. Use as much built-in functionality as possible
2. Must be usable on standard edition and higher
3. Must be usable on SQL Server 2005 and higher for as much as possible, and 2008 and higher where necessary (sorry, CLR is used so 2000 is out)
4. Must be cognizant of security concerns and attempt to minimize security holes as much as possible (ie, no xp_cmdshell, no injection holes, minimal domain access rights)
5. Document code in-line, and provide URL references if code/concepts are borrowed