Get Started With PowerShell for SQL Server

Presented on June 17, 2015 by Mike F Robbins, PowerShell MVP
What's this thing called PowerShell? Why should I care? And what can it do for me? During this beginner level session, PowerShell MVP and scripting games winner Mike F Robbins will be covering all of those questions and many more that are all too common among PowerShell noobs such as: How do I figure out what the commands are? And how do I extend PowerShell's functionality to manage products like SQL Server? The first beta of PowerShell was released 10 years ago and with it now being part of Microsoft's common engineering criteria, it's not going away any time soon so what are you waiting for?

[ruixue]

4:30 Started
5:28 session content
6:04 What is PowerShell
8:36 Background Information
8:48 Select "Run as Administrator" when opening PowerShell
9:28 command: Get-Help -Name Get-Alias
9:50 How do I figure out what the commands are
10:02 Get-Command
10:12 Get-Help
10:19 Get-Member
* 10:25 How do I get the SQL PowerShell module?
11:07 Command: Get-Command -Module SQL*
12:37 Get-Service -Name BITS
* 18:08 ExecutionPolicy (this can disable or enable running scripts !)
18:16 the default ExecutionPolicy is restricted
18:20 If SQLPS Module needs to be imported, restricted ExecutionPolicy would not work
* 19:32 command: Set-ExecutionPolicy RemoteSigned
30:00 pipeline
45:00 How to run MS SQL commands in Powershell
48:33 Command: Get-Command -Module SQLPS
49:22 Command: Get-PSSnapin
50:20 Command: Exit-PSSession
* 50:25 Invoke-Command
* 50:54 Command: Invoke-Sqlcmd -ServerInstance localhost -Database master -query "select * from sys.databases"

[davidmccallum]

Fantastic video.  So many little tips and tricks even for experienced PowerShell people.

[georgek]

Thank You! Lots of good info clearly presented, but only about last 10 minutes about SQL Server

[aravindkamath]

Nice, Helped me to get my program executed :) Thanks