Please enable Javascript, which is required for this site.
powershell-and-sql-server

PowerShell and SQL Server

Learn how to use PowerShell with SQL Server to perform common DBA and Developer tasks.

Authored by: Robert Cain
Duration: 2h 47m
Level: Intermediate
Released: 6/26/2012
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableBasic DBA Tasks with PowerShell
 You have not watched this Module. 00:44:27
Introduction
You have not watched this Clip. 06:30
Services
You have not watched this Clip. 09:56
Counters
You have not watched this Clip. 04:58
WMI
You have not watched this Clip. 09:13
The Event Log
You have not watched this Clip. 13:26
Summary
You have not watched this Clip. 00:24
This module is unavailableIntro to SMO and the SQL Provider
 You have not watched this Module. 00:32:39
Intro
You have not watched this Clip. 06:10
Loading SMO and the SQL Provider
You have not watched this Clip. 06:02
Navigating the SQL Provider
You have not watched this Clip. 03:20
Using the SQL Provider
You have not watched this Clip. 04:28
Intro to SMO
You have not watched this Clip. 06:21
Using SMO
You have not watched this Clip. 06:02
Summary
You have not watched this Clip. 00:16
This module is unavailableDBA Tasks using SMO and SQL Provider
 You have not watched this Module. 00:28:02
Intro
You have not watched this Clip. 02:15
Database Metadata
You have not watched this Clip. 12:05
Table Metadata
You have not watched this Clip. 05:12
Backups
You have not watched this Clip. 03:43
SMO Only Tasks
You have not watched this Clip. 02:30
Relating SMO and the SQL Provider
You have not watched this Clip. 01:51
Summary
You have not watched this Clip. 00:26
This module is unavailableDeveloper Tasks Using the SQL Provider
 You have not watched this Module. 00:20:00
Intro
You have not watched this Clip. 01:57
Creating Databases
You have not watched this Clip. 07:06
Creating Tables and Inserting Data
You have not watched this Clip. 03:49
Reading Data
You have not watched this Clip. 05:28
Dropping the Database
You have not watched this Clip. 01:25
Summary
You have not watched this Clip. 00:15
This module is unavailableDeveloper Tasks Using the SMO
 You have not watched this Module. 00:24:09
Intro
You have not watched this Clip. 01:50
Creating Databases
You have not watched this Clip. 04:26
Creating Tables
You have not watched this Clip. 05:24
Adding Indexes
You have not watched this Clip. 05:15
Inserting Data
You have not watched this Clip. 00:57
Reading Data
You have not watched this Clip. 03:53
Updating Data, Dropping the Database
You have not watched this Clip. 01:59
Summary
You have not watched this Clip. 00:25
This module is unavailableReal World Examples, SQL PS, PowerShell Jobs
 You have not watched this Module. 00:18:24
Intro
You have not watched this Clip. 01:59
Real World Example
You have not watched this Clip. 11:46
SQLPS
You have not watched this Clip. 02:32
PowerShell and SQL Server Jobs
You have not watched this Clip. 01:37
Summary
You have not watched this Clip. 00:30