Managing and Configuring SQL Server with PowerShell

Managing and Configuring SQL Server with PowerShell - What you will need to get started

Module 00 - Course Introduction - Managing and Configuring SQL Server with PowerShell 10 min.

Module 01A - Modules for SQL (Overview) 12 min.

Module 01B - Modules for SQL (Getting the Modules and Resources) 12 min.

Module 01C - Modules for SQL (Connecting with PowerShell) 9 min.

Module 02A - DML Tasks with PowerShell (Overview) 11 min.

Module 02B - DML Tasks with PowerShell (Querying Tables) 23 min.

Module 02C - DML Tasks with PowerShell (Inserting, Updating, Deleting) 18 min.

Module 02D - DML Tasks with PowerShell (Review) 1 min.

Module 03A - DDL Tasks with PowerShell (Overview) 7 min.

Module 03B - DDL Tasks with PowerShell (Creating and Editing) 26 min.

Module 03C - DDL Tasks with PowerShell (Dropping Database Objects) 14 min.

Module 04A - DCL Tasks with PowerShell (Overview) 11 min.

Module 04B - DCL Tasks with PowerShell (Creating Logins and Granting Access) 9 min.

Module 04C - DCL Tasks with PowerShell (Login Lifecycles) 10 min.

Module 04D - DCL Tasks with PowerShell (Auditing Systems) 9 min.

Module 04E - DCL Tasks with PowerShell (Review) 1 min.

Module 05A - Backups and Agent Jobs (Overview) 16 min.

Module 05B - Backups and Agent Jobs (Backups) 21 min.

Module 05C - Backups and Agent Jobs (Agent Jobs) 15 min.

Module 05D - Backups and Agent Jobs (Review) 2 min.

Module 06A - Managing SSRS With PowerShell (Overview) 10 min.

Module 06B - Managing SSRS with PowerShell (Managing Report Services) 27 min.

Module 07A - Testing Your Instances (Overview) 15 min.

Module 07B - Testing your Instances Demo (Using DbaChecks) 34 min.

Module 08A - PowerShell Desired State Configuration (Overview) 21 min.

Module 08B - PowerShell Desired State Configuration (Setting LocalConfigurationManager) 26 min.

Module 09A - Installing SQL Server via a Push Deployment (Overview) 10 min.

Module 09B - Installing SQL Server via a Push Deployment (Installing SQL Server with a Push Config) 57 min.

Module 10A - Maintaining Settings with a Pull Deployment (Overview) 13 min.

Module 10B - Maintaining Settings with a Pull Deployment (Setting up a Pull Server) 22 min.

Module 10C - Maintaining Settings with a Pull Deployment (Using Azure Automation) 32 min.