GoToWebinar - Painting with PowerShell: SQL Server Administration

The SQL Server canvas gives us limitless opportunity for scripting and automation, and PowerShell is the perfect brush to paint with. Configuring our database servers, deploying database code changes, performing backups and restores are just a few examples of a day in the life of a DBA. Automation and scripting bring consistency, simplicity and scalability to many of these sometimes daunting tasks. Join SQL Server DBA and PowerShell Nut Chris Sommer to learn how to paint your own SQL Server canvas with PowerShell.

Demos:
 * Manage SQL Services
 * Configure SQLServer
 * Configure SQL Agent
 * Deploy SSRS Reports
 * Migrate SQL Databases Using SQL Mirroring

Q: I am new to Power Shell. Does PS have to be run on the SQL server or can it be run on any machine that can attach to the SQL service?

A: Great Question! Think of SQLPS as the cmdline equivalent of SSMS. So you can run it from your local machine or from the server itself.