Getting Started with SQL and PowerShell

Course: 20 Minutes

• Course Introduction
• Introduction to PowerShell and SQL Server
• Working with Services
• PowerShell and the SQLConnection .NET Class

SQL Server Management Objects

Course: 34 Minutes

• Loading the SMO Assemblies into PowerShell
• Working with SQL Server Using SMO
• Working with Databases Using SMO
• Working with Tables Using SMO
• Backing up and Restoring with SM

Management and WMI

Course: 25 Minutes

• Managing SQL Server Services
• Managing Client Network Protocols with WMI
• Managing SQL Server Client Aliases with WMI
• Changing FILESTREAM Settings with WMI

Errors and Instances

Course: 25 Minutes

• Monitoring Errors from the SQL Server Error Log
• Advanced Monitoring Errors from the SQL Error Log
• Obtaining Instance Information on Multiple Instances
• Enabling PS Remoting on SQL Instance
• Error Handling

Working with SQL PowerShell

Course: 38 Minutes

• Restoring All Databases from Most Recent Backup
• Finding Disk Space for SQL Files
• Displaying Results in Grid View
• sqlps Utility
• Creating SQL Audits
• SQLSERVER Drive and Invoke Sqlcmd cmdlets

Policies

Course: 15 Minutes

• Course Introduction
• Policies
• Evaluate the SQL Policy

Jobs

Course: 36 Minutes

• PowerShell Job Step
• PowerShell from SSMS
• Execute SQL Scripts from File
• Create SQL Agent Job
• Execute SQL Agent Job
• Retrieve SQL Agent Job History

PowerShell Features

Course: 23 Minutes

• PowerShell Variables
• Piping
• Use PowerShell Utility to Create Stored Procedure

Working with Databases

Course: 42 Minutes

• Create Database
• Create Login
• Change Database User
• Create Schema
• Create Stored Procedure
• DBCC Using PowerShell
• Create XML Schema Collection
• Configure Database Mail

Authentication and Alerts

Course: 33 Minutes

• Connect to SQL Using SQL Authentication
• Change Server to Mixed Mode Authentication
• Drop Objects
• Send Query Results E-mail
• Create Operator
• Create Alert