Congratulations Dan! Reading the interview was inspiring. Your comments displayed the kind of intentful forward thinking that brought you the award.
I'm interested in the standardization maintenance script and how it handles the different DB requirements. Specifically, how do you address databases where the data does not change often, versus databases where the data changes a lot. Or those that use full text indexes, and those that don't. Or those where the vendor supplied application guidelines indicate YES or NO to rebuilding indexes. Do you perform analysis before building the SQL system and apply one of several preset methodologies? Do you handle all system db's on all systems the same or differently within the script?
With only a few servers and DB's to handle, I keep trying to figure out how best to provide maintenance to what appears to me to be completely different needs. I'm self taught so part of my education is just trying different methods and continuing to read up. I have put off gathering data into some type of a table or report, but want to move this forward.