PowerShell Scripting and Automation for SQL Server DBA

Automation, Automation using PowerShell, PowerShell Scripting for SQL Server Database Administrator

What you'll learn
Learn PowerShell Scripting for SQL Server Database Administrator from scratch and fulfill their own dream for automation
Learn about Automation Using PowerShell for SQL server DBA daily task.
In this course you will get in depth knowledge of PowerShell after that you will be able to develop the script using PowerShell easily.
You will get total 100+ scripts, you can download and start doing the practice after each session.
Frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.
Learn about PowerShell, Automation, scripting, Creating HTML Reporting with Color format!…
Acclerate about your career to becomes the future-ready Automation Engineer for SQL Server database administrator
Create HTML Report for SQL DBA Task and sent in email
HTML Reporting Using PowerShell
Automation Using Powershell Script for AZURE/Cloud SQL Server DBA
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.


Requirements
No Prior PowerShell Knowledge is required. You will learn everything you need to know.
Need Knowledge on SQL server DBA concepts
No Prior HTML Knowledge is required. You will learn everything you need to know.
No Prior SQL Programming Knowledge is required. You will learn everything you need to know.
Eagerness to learn PowerShell Scripting
Description
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.
Who this course is for:
SQL database administrator
SQL DBA
All the SQL database administrator who wants to learn the Automation using PowerShell
All the SQL database administrator who wants to automate the daily DBA Tasks
Automation for Azure Cloud for SQL DBA
HTML Report using Powershell for SQL Server
Health Check Report for SQL server
Doing multiple work for multiple of Server
PowerShell Scripting
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.
Become competent by learning PowerShell automation and stand different in the CROWD

More Info