Please share some advanced SIP plans for (DBA prospective) sql server 2005\2008. The SIP plans must save DBA time or production time.
I have implemented below mentioned SIP's in my current environment. Is there any other new\advanced SIP's for DBA?
1. Automated backup status report - using tsql code
2. Automated disk space report - using tsql code and powershell
3. Job status report (Index rebuild\checkdb\Statistics update)
Thanks in Advance.