PowerShell Scripting and Automation for SQL Server DBA

About this course

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 script5. Displaying the result in color6. Adding the time stamp in log file.7. Setting the variable8. Registry level of informationMonitoring / Generating ReportIn 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 shotThis report has been generated for Datab