PowerShell and SQL Server

Pluralsight
Course Summary
Learn how to use PowerShell with SQL Server to perform common DBA and Developer tasks.
-
+
Course Description
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.
-
+
Course Syllabus
Basic DBA Tasks with PowerShell- 44m 27s
—Introduction 6m 30s
—Services 9m 56s
—Counters 4m 58s
—WMI 9m 13s
—The Event Log 13m 26s
—Summary 0m 24sIntro to SMO and the SQL Provider- 32m 39s
—Intro 6m 10s
—Loading SMO and the SQL Provider 6m 2s
—Navigating the SQL Provider 3m 20s
—Using the SQL Provider 4m 28s
—Intro to SMO 6m 21s
—Using SMO 6m 2s
—Summary 0m 16sDBA Tasks using SMO and SQL Provider- 28m 2sDeveloper Tasks Using the SQL Provider- 20m 0sDeveloper Tasks Using the SMO- 24m 9sReal World Examples, SQL PS, PowerShell Jobs- 18m 44s