Microsoft PowerShell and SQL Server: Database Management

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

Prerequisite
None

Expected Duration
149 minutes

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.

Objective

Policies

  • start the course
  • use cmdlets to create and configure user defined policies in PowerShell
  • evaluate policies and output the result in PowerShell

Jobs

  • 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

PowerShell Features

  • use PowerShell variables
  • use piping in PowerShell
  • use the PowerShell Utility to create a Stored Procedure

Working with Databases

  • 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

Authentication and Alerts

  • 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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.