GoToWebinar - Painting with PowerShell: SQL Server Administration

From SQL Server Wiki
Jump to navigation Jump to search

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.


From: Robert Sterbal Sent: Tuesday, June 7, 2016 9:03 AM Subject: Painting with PowerShell: SQL Server Administration - YouTube

Published on Jun 6, 2016 Presented on Wednesday, June 1, 2016 by SQL DBA & PowerShell Enthusiast Chris Sommer. 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.

https://www.youtube.com/watch?v=I-HHDG8iQ0E

Let me know if you want a copy of the code samples if they get published.

Additional code samples can be found at:

https://onedrive.live.com/?authkey=%21AAQ7aBKdirDKY7Y&id=96D96169E2F8DFFB%21107&cid=96D96169E2F8DFFB

Additional videos can be found here:

https://www.youtube.com/c/powershellvirtualchapter


goto: PowerShell