Microsoft PowerShell and SQL Server: Database Management

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
PowerShell can be used to manage the full range of SQL Server management tasks, and through scripting can assist with automation of frequent tasks. This course covers policies and jobs, working with PowerShell’s powerful scripting features, and working with individual databases.

Target Audience
SQL Server administrators and developers looking to understand the command line interface to Microsoft SQL Server

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

Microsoft PowerShell and SQL Server: Database Management

start the course

use cmdlets to create and configure user defined policies in PowerShell

evaluate policies and output the result in PowerShell

create a PowerShell Job Step inside a SQL Server Agent Job

use Microsoft PowerShell to populate a table created in Microsoft SQL Server Management Studio using SQLCMD mode

execute SQL scripts from file locations in PowerShell

create SQL Server Agent Jobs in PowerShell

execute existing SQL Server Jobs in PowerShell

retrieve SQL Server Agent Job histories in PowerShell

use PowerShell variables

use piping in PowerShell

use the PowerShell Utility to create a Stored Procedure

create databases in PowerShell

use Microsoft PowerShell to create a Microsoft SQL Server login

use Microsoft PowerShell to change a SQL database's ownership

create a schema within a database using the PowerShell utility

create, alter, and drop a stored procedure using the PowerShell utility

pass your DBCC to each database using PowerShell

create a schema collection using PowerShell

configure and enable database mail using PowerShell

connect to an instance of SQL server using authentication in PowerShell

use PowerShell cmdlets to change an instance of SQL Server from Integrated Mode Authentication to Mixed Mode Authentication

use PowerShell cmdlets to drop an object within an instance of SQL Server

use PowerShell cmdlets to send SQL Server Query results through an SMTP e-mail

use PowerShell cmdlets to create an operator within SQL Server Agent

use PowerShell cmdlets to create error alerts for multiple errors simultaneously in SQL Server Agent

Course Number:
mw_pssq_a02_it_enus

Expertise Level
Intermediate