Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PowerShell for DBAs Fundamentals
Welcome to PowerShell
Intro to PowerShell
Syntax for DBAs
Constructs for DBAs
Commands
Modules
Scripts
Environment Setup
Execution Policy and Scopes
Windows 10 / Windows Server 2016
WinRM 5.1x
PowerShell Core
Homes of All the Things
Windows or Linux
Profile Setup
Installing Modules and Scope
PowerShell Language Fundamentals
Where to Start with PowerShell
Correlations to TSQL to help Learn PowerShell
Precursor to the Rest of the Story
Cmdlets and Pipeline
What are Cmdlets and Why do I care?
Pipeline Fundamentals
Key Pieces to know for maximizing Pipeline operations
Working with Objects
Everything in PowerShell is an Object
Every object derives from System.Object
Properties / Methods / Events
Every object has a Type
Creating Objects Correctly
Loops and Logical Operators for DBAs
Types of Loops
Operators in PowerShell
Comparison Operators
Learning more about Operators
How to apply these to DBA work
Functions and Parameters
Pattern for Functions in PowerShell
Fundamentals for Functions
Fundamentals for Parameters
CmdletBinding
Decoration of Parameters
Default Values
Pipeline Input for Functions/Cmdlets
What is next?
PowerShell Providers Explained
Get-PSDrive
How Providers Work in PowerShell
New-PSDrive and it's uses
The SQL Server Provider
SQL Server Provider explained
Navigation Anomalies to Understand
Objects from the Provider
Provider Authentication
Modules in PowerShell for the DBA
What is a Module and Why Do I Care?
DBATools
SQL Server
DBAChecks
ImportExcel
Other Modules you Want!
Scripting SQL Server Objects using SMO
Preparation for Scripting
Script Method
Dependencies and Scripting
Saving your Default Options
Tips and Tricks for Scripting
PowerShell and SQL Server - including Agent
Agent Objects
Agent Jobs and Alternatives
Operators
DBMail
Auditing Database Permissions
Options for the DBA
Going Parallel and Getting More Done
PowerShell Jobs
PoshRSJob Module
PowerShell 7
Benefits and Risks
What's Next for the DBA in PowerShell
When do I use TSQL and when do I use SMO?
Teaching a DBA to Fish
Properties / Methods / Events
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock