Manage multiple machines at once using PowerShell. Learn how to use PowerShell to create objects, populate and delete data from tables, remote to other servers, and more.
Overview
Syllabus
Introduction
- Manage SQL servers with PowerShell
- What you should know
- Download tools
- PowerShell won't solve all problems
- When PowerShell is useful
- Differences between the two modules
- Open-source solutions
- Declaring objects
- Connecting to SQL Server
- Parameters in PowerShell
- Closing connections
- Disposing connections
- Object reuse
- Creating databases
- Creating tables
- Creating views
- Creating procedures
- Inserting data into tables
- Returning data from SQL Server
- Running stored procedures in PowerShell
- Loops in PowerShell
- Storing servers for PowerShell
- Concepts of threading
- PowerShell threading commandlets
- Authentication and threading
- Piping between objects
- Exporting CSV files
- Importing CSV files
- Exporting XML data
- Importing XML data
- What is remoting?
- Removing over HTTP ports
- Enabling remoting via PowerShell
- Enabling remoting via GPO
- Starting a remote session
- Ending a remote session
- Using alternate credentials for remoting
- Invoking a remote command
- Next steps
Taught by
Denny Cherry
