PowerShell Fundamentals for SQL Server DBAs

  Welcome to PowerShell

Available in days

days after you enroll

• Intro to PowerShell Start
• Syntax for DBAs Start
• Constructs for DBAs Start
• Commands Start
• Modules Start
• Scripts Start

  Environment Setup

Available in days

days after you enroll

• Execution Policy and Scopes Start
• Windows 10 / Windows Server 2016 Start
• WinRM 5.1x Start
• PowerShell Core Start
• Homes of All the Things Start
• Windows or Linux Start
• Profile Setup Start
• Installing Modules and Scope Start

  PowerShell Language Fundamentals

Available in days

days after you enroll

• Where to Start with PowerShell Start
• Correlations to TSQL to help Learn PowerShell Start
• Precursor to the Rest of the Story Start

  Cmdlets and Pipeline

Available in days

days after you enroll

• What are Cmdlets and Why do I care? Start
• Pipeline Fundamentals Start
• Key Pieces to know for maximizing Pipeline operations Start

  Working with Objects

Available in days

days after you enroll

• Everything in PowerShell is an Object Start
• Every object derives from System.Object Start
• Properties / Methods / Events Start
• Every object has a Type Start
• Creating Objects Correctly Start

  Loops and Logical Operators for DBAs

Available in days

days after you enroll

• Types of Loops Start
• Operators in PowerShell Start
• Comparison Operators Start
• Learning more about Operators Start
• How to apply these to DBA work Start

  Functions and Parameters

Available in days

days after you enroll

• Pattern for Functions in PowerShell Start
• Fundamentals for Functions Start
• Fundamentals for Parameters Start
• CmdletBinding Start
• Decoration of Parameters Start
• Default Values Start
• Pipeline Input for Functions/Cmdlets Start
• What is next? Start

  PowerShell Providers Explained

Available in days

days after you enroll

• Get-PSDrive Start
• How Providers Work in PowerShell Start
• New-PSDrive and it's uses Start

  The SQL Server Provider

Available in days

days after you enroll

• SQL Server Provider explained Start
• Navigation Anomalies to Understand Start
• Objects from the Provider Start
• Provider Authentication Start

  Modules in PowerShell for the DBA

Available in days

days after you enroll

• What is a Module and Why Do I Care? Start
• DBATools Start
• SQL Server Start
• DBAChecks Start
• ImportExcel Start
• Other Modules you Want! Start

  Scripting SQL Server Objects using SMO

Available in days

days after you enroll

• Preparation for Scripting Start
• Script Method Start
• Dependencies and Scripting Start
• Saving your Default Options Start
• Tips and Tricks for Scripting Start

  PowerShell and SQL Server - including Agent

Available in days

days after you enroll

• Agent Objects Start
• Agent Jobs and Alternatives Start
• Operators Start
• DBMail Start

  Auditing Database Permissions

Available in days

days after you enroll

• Options for the DBA Start

  Going Parallel and Getting More Done

Available in days

days after you enroll

• PowerShell Jobs Start
• PoshRSJob Module Start
• PowerShell 7 Start
• Benefits and Risks Start

  What's Next for the DBA in PowerShell

Available in days

days after you enroll

• When do I use TSQL and when do I use SMO? Start
• Teaching a DBA to Fish Start

  Demo Download

Available in days

days after you enroll

• Demos Start