Professional- Automation using PowerShell Script for SQL DBA

Name: Professional- Automation using PowerShell Script for SQL DBA
Rating: 5.0 (7 reviews)

Professional way of writing PowerShell Script for SQL DBA and automate the daily DBA task , PowerShell for SQL DBA

Created byRajesh J

Last updated 6/2026

English

What you'll learn

Advanced Level of PowerShell Scripting for SQL Server Database Administrator.
Fulfill their own dream for automation using PowerShell.
Professional way of writing the PowerShell Script for SQL DBA
Frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.
This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and develop PowerShell script at the end of course.
Automation Using Powershell Script for AZURE/Cloud SQL Server DBA by applying same logic
Create HTML Reporting
PowerShell for SQL DBA
PowerShell Scripts for SQL DBA

Course content

5 sections • 43 lectures • 25h 4m total length

Introduction14:21
Welcome to Introduction.

How to Pass Parameter from Configuration File from SQL Agent43:39
How to Pass Parameter from Configuration File from SQL Agent.
Initializes the Program with Parameters passed29:07
Initializes the Program with Parameters passed
Understanding of args[0] and args.count in Powershell Script28:42
Understanding of args[0] and args.count in Powershell Script
How to Read Values from Config File and Fixing human error1:02:03
How to Read Values from Config File and Fixing human error
Powershell Script without configuration value in config file23:35
Powershell Script without configuration value in config file
Setting the Log-Location for Powershell Script26:29
Setting the Log-Location for PowerShell Script
How to Find SQLCMD.EXE Path using Registory54:34
How to Find SQLCMD.EXE Path using Registory
How to write Logs information in to Log files26:30
How to write Logs information in to Log files
Check Database is available or not38:32
Check Database is available or not
Explanation of all videos which we have learned till now1:01:46
Explanation of all videos which we have learned till now
Check Database and Server if not available write in log file with error details33:32
Check Database and Server if not available write in log file with error details
Backs-up the database27:17
Backs-up the database
Passing Wrong Database from config file and checking how my log file will re21:03
Passing Wrong Database from config file and checking how my log file will re
Passing Offline Database from config file, checking how my log file will react20:39
Passing Offline Database from config file, checking how my log file will react
Passing insufficient resources Database from config file, how log will react20:54
Passing insufficient resources Database from config file, how log will react
Passing Multiple of Database name with one Wrong DB Name from Config file44:38
Passing Multiple of Database name with one Wrong DB Name from Config file
Implementation of Database Exclude logic from Database Dump list23:23
Implementation of Database Exclude logic from Database Dump list
Taking Database Dump from List of databases after excluding DBS59:07
Taking Database Dump from List of databases after excluding DBS
Database Dump from passing All_DB from config file after excluding DBS54:52
Database Dump from passing All_DB from config file after excluding DBS
System DB Dump from passing All_System_DB from config file after excluding DBS34:11
System DB Dump from passing All_System_DB from config file after excluding DBS
System DB Dump and same database will be pass in EXCLUDE_LIST19:06
System DB Dump and same database will be pass in EXCLUDE_LIST
All User DB Dump to be performed52:20
All User DB Dump to be performed

Creating Basic Always-On HealthCheck Report58:22
Creating Basic Always-On HealthCheck Report
Set the Environment for Always-ON HelthCheck Report in Powershell Script51:14
Set the Environment for Always-ON HelthCheck Report in Powershell Script
Always-ON HealthCheck Report Final1:01:24
Always-ON HealthCheck Report Final
How to send Always-ON HelthCheck Report in Email (Gmail or Exchange)14:59
How to send Always-ON HelthCheck Report in Email (Gmail or Exchange)

Login Creation and Assigning the Permission in Always ON Secoundary Replica31:45
Login Creation and Assigning the Permission in Always ON Secoundary Replica
Automation-1 Setting the Environment using PowerShell Script -Part-137:04
Automation-1 Setting the Environment using PowerShell Script -Part-1
Automation-2 Setting the Environment using PowerShell Script -Part-216:22
Automation-2 Setting the Environment using PowerShell Script -Part-2
How to Get SQL CMD Path from Registry using PowerShell50:00
How to Get SQL CMD Path from Registry using PowerShell
Implementing function to get SQLCMD path in PowerShell Script.11:02
Implementing function to get SQLCMD path in PowerShell Script.
Implementing - Check Availability for Database and Server30:00
Implementing - Check Availability for Database and Server
Check Database Is Part of AG or not15:38
Check Database Is Part of AG or not
CASE-1 : When login and User is not present in Primary and Secondary Replica.43:59
CASE-1 : When login and User is not present in Primary and Secondary Replica.
Implementing - Check Availability for Database and Server30:00
Implementing - Check Availability for Database and Server
CASE-2 : login present only in Primary and user not available in any Replica.38:31
CASE-2 : login present only in Primary and user not available in any Replica.
CASE-3 : login & User not present in Primary Replica but Login Present in Secoun34:44
CASE-3 : login & User not present in Primary Replica but Login Present in Secoun
CASE-4: login & User are present in Primary Replica26:20
CASE-4: login & User are present in Primary Replica

Requirements

Basic PowerShell Knowledge is required because this is advanced version of Powershell Automation.
Basic PowerShell Knowledge or any Programing Knowledge is required.
If it's possible Please complete the course - PowerShell Scripting and Automation for SQL Server DBA
Need Knowledge on SQL server DBA concepts

Description

In this course you will get in depth Scripting and Programming knowledge of PowerShell automation. After completing this course, you will be able to develop the script using PowerShell in Professional way. This course provides you better understanding of PowerShell. IF you are SQL Server database administrator looking to enhance your skills and streamline your workflow this going to the best course for you.

I will be frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.

This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and develop the script using end of this course.

At the end of each module, you will get the final scripts which having more than 1000 to 3000 lines which include the multiple of logic in single script.

In this course, you'll embark on a transformative journey, starting with the basics of PowerShell and gradually advancing to more complex topics tailored specifically for SQL Server administration. Whether you're a beginner or an experienced DBA, our course is structured to meet your needs and elevate your expertise.

Enroll now and become a proficient and Professional SQL Server DBA and Automate your Task.

Who this course is for:

SQL Server DBAs with any level of experience
Those want to learn the Automation using Powershell
SQL database administrator
SQL DBA
Automation for Azure Cloud for SQL DBA
PowerShell Scripting
Become competent by learning PowerShell automation and stand different in the CROWD
Anybody who is interested in Automating tasks for SQL DBA can checkout this video. You can play around using the commands and scripts to create your own Application.
PowerShell for SQL DBA
PowerShell Scripts for SQL DBA

Professional- Automation using PowerShell Script for SQL DBA

What you'll learn

Explore related topics

Course content

Intruduction1 lecture • 14min

Taking the Backup using Powershell Script (Set the environment for Script)22 lectures • 13hr 26min

Always-On HealthCheck Report4 lectures • 3hr 6min

PowerShell Automation - Create Login on Secondary Read Only Replica in AlwaysOn12 lectures • 6hr 5min

Delete Old Dump/Backup file using Powershell Script4 lectures • 2hr 13min

Requirements

Description

Who this course is for: