Managing and Configuring SQL Server with PowerShell

Part Of The On-Demand Courses


  • To use Windows PowerShell to automate and manage SQL Server
  • DML, DDL and DCL tasks with PowerShell
  • How to test your instances
  • To install SQL Server via a push deployment and maintain settings with a pull deployment
This course includes:

Course Description

This class is designed to show you how to use Windows PowerShell to automate and manage SQL Server. Throughout this course we will look at domain specific topics for data professionals, including cmdlets for traditional DBA workloads (DML, DDL, DCL), cmdlets for Reporting Services, community-built cmdlets, and the SMO provider. We will also introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. This course will include Labs and Projects that will help you practice what you learn. By the end of this course you should feel comfortable writing your own scripts for managing SQL Server.



Module 00 | Course Introduction
09m 35s total


Module 00A | Course Introduction
09m 35s


Module 01 | Modules for SQL
33m 37s total


Module 01A | Modules for SQL Overview
12m 00s


Module 01B | Getting the Modules and Resources
12m 26s


Module 01C | Connecting with PowerShell
09m 11s


Module 02 | DML Tasks with PowerShell
54m 09s total


Module 02A | DML Tasks with PowerShell Overview
11m 12s


Module 02B | Querying Tables
23m 15s


Module 02C | Inserting, Updating, Deleting
18m 16s


Module 02D | DML Tasks with PowerShell Review
01m 26s


Module 03 | DDL Tasks with PowerShell
39m 32s total


Module 03A | DDL Tasks with PowerShell Overview
07m 06s


Module 03B | Creating and Editing
18m 06s


Module 03C | Dropping Database Objects
14m 20s


Module 04 | DCL Tasks with PowerShell
39m 44s total


Module 04A | DCL Tasks with PowerShell Overview
11m 05s


Module 04B | Creating Logins and Granting Access
08m 38s


Module 04C | Login Lifecycles
10m 01s


Module 04D | Auditing Systems
08m 41s


Module 04E | DCL Tasks with PowerShell Review
01m 19s


Module 05 | Backups and Agent Jobs
44m 49s total


Module 05A | Backups and Agent Jobs Overview
16m 22s


Module 05B | Backups
20m 51s


Module 05C | Agent Jobs
05m 18s


Module 05D | Backups and Agent Jobs Review
02m 18s


Module 06 | Managing SSRS With PowerShell
37m 27s total


Module 06A | Managing SSRS With PowerShell Overview
10m 17s


Module 06B | Managing Report Services
27m 15s


Module 07 | Testing Your Instances
49m 31s total


Module 07A | Testing Your Instances Overview
15m 22s


Module 07B | Using DbaChecks
34m 10s


Module 08 | PowerShell Desired State Configuration
30m 15s total


Module 08A | PowerShell Desired State Configuration Overview
21m 16s


Module 08B | Setting Local Configuration Manager
08m 59s


Module 09 | Installing SQL Server via a Push Deployment
67m 43s total


Module 09A | Installing SQL Server via a Push Deployment Overview
10m 15s


Module 09B | Installing SQL Server with a Push Config
57m 28s


Module 10 | Maintaining Settings with a Pull Deployment
39m 49s total


Module 10A | Maintaining Settings with a Pull Deployment
05m 34s


Module 10B | Setting up a Pull Server
02m 32s


Module 10C | Using Azure Automation
31m 43s



IT Systems Engineer
Joshua is a Systems Engineer at the University of North Florida and has been in this position for 2 years. Joshua wears many different hats in his role, but tends to be given the DBA responsibilities. He is also a passionate advocate for PowerShell and automation of any fashion. He is a husband and father of two boys and has lived in Jacksonville, FL since 2014.

System Requirements

  • SQL Server 2016 or higher
  • A• SQL Server PowerShell Modules
  • Microsoft Windows 7, Windows 8 or 8.1 desktop or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space

What to Know Before Class

We recommend first taking the Introduction to PowerShell course first but this is not mandatory.


Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!