Fundamentals of PowerShell for DBAs

Before the Class

• Welcome and Class Roadmap 17:45
• How Drew Sets Up His Workstation 7:06
• Setting Up Your Computer 2:13
• Download the Slide Decks and Helper Files

Working with Variables and CMDLETs

• What’s PowerShell? 13:08
• Using Variables and Lab 1 23:58
• CMDLETs and the Pipeline: Lecture 8:25
• Demos 14:46
• Aliasing and the Pipeline: Lecture 4:47
• Demo 9:17
• Lab 2 1:51

Working with Objects

• Lecture 6:39
• Demo 4:56
• Object Properties and the Pipeline: Lecture 3:35
• Demo 9:19
• Object Methods 8:42
• Making Your Own Objects 5:34
• Lab 3 2:00

Logical Operators and Loops

• Lecture 6:30
• Demo 15:06
• Filtering with WHERE 9:54
• WHILE Loops: Lecture 5:59
• Demo 6:03
• IF/THEN/ELSE 5:21
• Lab 4 2:30

Functions and Parameters

• Lecture 9:21
• Demo 7:19
• Parameters and Error Handling: Lecture 9:26
• Demo 29:54
• Lab 5 5:21

Using PowerShell with SQL Server

• The SQL Server Module: Lecture 12:57
• Demo 13:21
• The SQLSERVER:\ Drive 20:34
• Working With SQLSERVER Objects 12:45
• Lab 6 2:28

Scripting SQL Server Objects

• Lecture 4:03
• Demo 15:53
• Objects and Namespaces 8:05
• Lab 7 2:46

SQL Server Agent Jobs

• PowerShell and the SQL Server Agent 12:58
• Creating Agent Jobs 5:39
• Scheduling PowerShell Job Steps 19:17
• Lab 8 3:04

Putting It All Together: Auditing Permissions

• Lecture 6:26
• Demo 15:30
• Exporting the Permissions to CSV 11:18
• Lab 9 2:07

Recap and What To Do Next

• Okay, What’s Next? 8:41