2012
pluralsight-training.net
Robert Cain
02:47:41
English
This course is designed to teach you the fundamentals of using PowerShell to manage your SQL Servers, as well as develop on them. In Module 1, we cover basic DBA tasks using just PowerShell. With Module 2, we provide an introduction to the two main tools for working with SQL Server, the SMO, or SQL Management Objects, and the SQL Server Provider. Module 3 will cover basic DBA tasks using both SMO and the SQL Provider. With Module 4 we switch to Developer mode and cover development using the SQL Provider. Module 5 continues the developer theme, this time using the SQL Management Objects. We finally wrap things up with Module 6, in which we go over a real world example of using PowerShell and SQL Server. We also cover the SQL PS mode of PowerShell, as well as how to make effective use of PowerShell from a SQL Server job.
Basic DBA Tasks with PowerShell 00:44:27
Introduction 06:30
Services 09:56
Counters 04:58
WMI 09:13
The Event Log 13:26
Summary 00:24
Intro to SMO and the SQL Provider 00:32:39
Intro 06:10
Loading SMO and the SQL Provider 06:02
Navigating the SQL Provider 03:20
Using the SQL Provider 04:28
Intro to SMO 06:21
Using SMO 06:02
Summary 00:16
DBA Tasks using SMO and SQL Provider 00:28:02
Intro 02:15
Database Metadata 12:05
Table Metadata 05:12
Backups 03:43
SMO Only Tasks 02:30
Relating SMO and the SQL Provider 01:51
Summary 00:26
Developer Tasks Using the SQL Provider 00:20:00
Intro 01:57
Creating Databases 07:06
Creating Tables and Inserting Data 03:49
Reading Data 05:28
Dropping the Database 01:25
Summary 00:15
Developer Tasks Using the SMO 00:24:09
Intro 01:50
Creating Databases 04:26
Creating Tables 05:24
Adding Indexes 05:15
Inserting Data 00:57
Reading Data 03:53
Updating Data, Dropping the Database 01:59
Summary 00:25
Real World Examples, SQL PS, PowerShell Jobs 00:18:24
Intro 01:59
Real World Example 11:46
SQLPS 02:32
PowerShell and SQL Server Jobs 01:37
Summary 00:30
http://pluralsight.com/training/Courses/TableOfContents?courseName=powershell-and-sql-server
Download File Size:275.6 MB
|
