PowerShell for SQL Server Administration

PowerShell for SQL Server Administration
PowerShell for SQL Server Administration
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2 Hours | 246 MB

Since SQL Server database administrators are typically charged with managing multiple machines, PowerShell—which enables administrators to manage large numbers of servers—is an especially valuable tool to master. In this course, instructor Denny Cherry shows SQL Server administrators how to use PowerShell to automate server management. Discover how to work with PowerShell to create objects, populate and delete data from tables, and remote to other servers. Plus, see how to loop constructs in PowerShell and make data available for transfer to third-party platforms.

Topics include:

  • When PowerShell can be particularly useful
  • Connecting to SQL Server from PowerShell
  • Closing connections
  • Creating objects in PowerShell
  • Creating tables, views, and procedures
  • Querying data in PowerShell
  • Using loops in PowerShell
  • Exporting CSV files and XML data
Table of Contents

1 Manage SQL servers with PowerShell
2 What you should know
3 Download tools
4 PowerShell won’t solve all problems
5 When PowerShell is useful
6 Differences between the two modules
7 Open-source solutions
8 Declaring objects
9 Connecting to SQL Server
10 Parameters in PowerShell
11 Closing connections
12 Disposing connections
13 Object reuse
14 Creating databases
15 Creating tables
16 Creating views
17 Creating procedures
18 Inserting data into tables
19 Returning data from SQL Server
20 Running stored procedures in PowerShell
21 Loops in PowerShell
22 Storing servers for PowerShell
23 Concepts of threading
24 PowerShell threading commandlets
25 Authentication and threading
26 Piping between objects
27 Exporting CSV files
28 Importing CSV files
29 Exporting XML data
30 Importing XML data
31 What is remoting
32 Removing over HTTP ports
33 Enabling remoting via PowerShell
34 Enabling remoting via GPO
35 Starting a remote session
36 Ending a remote session
37 Using alternate credentials for remoting
38 Invoking a remote command
39 Next steps