Get Started With PowerShell for SQL Server

[@ruixue6955]

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"

[@danshepard6851]

THANK YOU!!

[@BalvinderSingh-uh3my]

That is really, really helpful thanks.

[@davidmccallum4794]

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

[@georgek9893]

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

[@aravindkamath1367]

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