1.1 Welcome and Class Roadmap
Drew introduces himself and talks about what we’re going to cover in the class. Download the slide decks and helper files here. Last updated Feb 22, 2023.
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Recorded Class Season Pass – or Recorded Class Season Pass – , or log in if you already shelled out the cash.
Drew introduces himself and talks about what we’re going to cover in the class. Download the slide decks and helper files here. Last updated Feb 22, 2023.
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Recorded Class Season Pass – or Recorded Class Season Pass – , or log in if you already shelled out the cash.
- 1.2 How Drew Sets Up His Workstation
- 1.3 Setting Up Your Computer
- 2.1 What’s PowerShell?
- 2.2 Using Variables and Lab 1 Assignment
- 2.3 Using CMDLETs and the Pipeline
- 2.4 CMDLETs: Aliasing and the Pipeline
- 2.5 Lab 2 Assignment
- 3.1 Working with Objects
- 3.2 Object Properties and the Pipeline
- 3.3 Object Methods
- 3.4 Making Your Own Objects
- 3.5 Lab 3 Assignment
- 4.1 Logical Operators and Loops
- 4.2 Filtering with WHERE
- 4.3 WHILE Loops
- 4.4 IF – THEN – ELSE
- 4.5 Lab 4 Assignment
- 5.1 Functions and Parameters
- 5.2 Parameters and Error Handling
- 5.3 Lab 5 Assignment
- 6.1 The SQL Server PowerShell Module
- 6.2 The SQLSERVER:\ Drive
- 6.3 Working with SQLSERVER:\ Objects
- 6.4 Lab 6 Assignment
- 7.1 Scripting SQL Server Objects with PowerShell
- 7.2 Objects and Namespaces
- 7.3 Lab 7 Assignment
- 8.1 PowerShell and the SQL Server Agent
- 8.2 Creating Agent Jobs with PowerShell
- 8.3 Scheduling PowerShell Job Steps
- 8.4 Lab 8 Assignment
- 9.1 Auditing Permissions with PowerShell
- 9.2 Exporting Permissions to CSV
- 9.3 Lab 9 Assignment
- 9.4 What’s Next for You