Damon Wilson (4/14/2008)

---

Bill,

Thanks for taking the time to write this article. I have implemented a similar process in my environment. To collect the majority of my data, I use a modified version of David Bird's SQL Overview SSIS Package.


SQL Overview Part 1
By David Bird, 2008/01/07
http://www.sqlservercentral.com/articles/Integration+Services/61621/

SQL Overview SSIS Package II - Retrieving SQL Error Log
By David Bird, 2008/01/14
http://www.sqlservercentral.com/articles/Integration+Services/61714/

SQL Overview SSIS Package III - Full Package
By David Bird, 2008/01/22
http://www.sqlservercentral.com/articles/Integration+Services/61774/


Using David's articles and SSIS code, I have customized it for the uniqueness of the systems which I am responsible for. Your idea of printing everything out and storing in a binder with signatures, will be a a topic for discussion with my next planning meeting with my boss. I look forward to your future SSC postings.

Regards,

rubes (4/14/2008)

---

Nice article. I would just like to point out that for those of us that have numerous servers, automation of the checklist is critical. If you're dealing with only one server, manually checking these things does not take a lot of time. But imagine checking job failures or drive space on 50 sql servers. We get paid too much to perform these menial tasks by hand. There are many 3rd party tools out there that do this for us. It's also pretty easy to write your own scripts and sql jobs... many starter scripts could probably be found on this forum.