John.Sansom (4/6/2012)
SQL-Expat, PowerShell can certainly help you with some of these tasks.
Agreed, I only picked up PowerShell a few months back, but it has been a life saver.
It has allowed me to:
- Populate a central repository of completed backups from all remote servers to watch for failures using SSRS.
- Script a remote start up and shut down of all SAP services on SQL clusters for monthly patching.
- Script the remote startup and shutdown of SQL services and bouncing of servers.
- Push SQL Alerts to all SQL servers to create some standards across our global infrastructure.
If you haven't used it yet, I would begin reading. Very easy to pick up.