7.3 Lab 7 Assignment
When you’re done, check your work against the Lab 7 Answers.ps1 file in your downloads. (If you downloaded ’em before Feb 21, 2023, download ’em again – we updated this lab’s answers.)
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.
When you’re done, check your work against the Lab 7 Answers.ps1 file in your downloads. (If you downloaded ’em before Feb 21, 2023, download ’em again – we updated this lab’s answers.)
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.1 Welcome and Class Roadmap
- 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
- 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