PowerShell Scripting and Automation for SQL Server DBA

In this course you will get in depth knowledge of PowerShell after that you will be able to develop the script using PowerShell easily.

Basically, this course has been divided in to 20 sessions/Module which include the HTML Session, Evendu you will find the others additional session in this course, which will be the subcategory of the main course. For Sub-category you have to go through each Module.

I am going to provide and discussed total 100+ script, you can download and start doing the practice after each session.

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 PowerShell for SQL DBA at the end of this course.

In this session will cover that how to start writing the PowerShell script from basic to advance level. It will be going to include Daily DBA Task like - Backup, Restore, how to script the Database objects, creating and scheduling SQL Job in Single or Multiple servers. Running the script in multiple servers, BCP IN and BCP out, how to schedule the script using task scheduler or SQL Agent and many more things. How to pass the parameter using config file, creating own module ETC.

Standard way of writing the script.

1. Generating log file for any script.

2. Ping the server.

3. Passing multiple parameters using single configuration file.

4. Creating function in script

5. Displaying the result in color

6. Adding the time stamp in log file.

7. Setting the variable

8. Registry level of information

Monitoring / Generating Report

In this session we are going to work on SQL Server Monitoring Part and Generating and sending the alert/Notification using email in HTML body or as attachments. As per below screen shot

This report has been generated for Database file usage as HTML body.

We are going to learn that how to generate the Health check report and monitoring the many things.

a. Monitoring like Database data files and log file space.

b. Disk space monitoring for single of multiple of servers.

c. CPU or Ram usage monitoring.

d. Long running job, Blocking, Deadlock etc

e. Creating report for Backup status.

f. Job Failed status report.

g. Sending the alert/Notification if any services will be down.

· HTML

a. Basic of HTML

b. Static and Dynamic HTML Report

c. How customize the HTML report and adding some comment.

d. Sending email in the format of HTML body using PowerShell.

· Cloud (Going to be Uploaded very Soon)

a. Basic of Azure Cloud

b. How to develop the PowerShell scripts for AZURE cloud.