• 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.