MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 10.54 GB | Duration: 14h 20m
SQL Server, HTML ,HTML Report , HTML Health Check Report for SQL server using PowerShell, SQL server database administr
What you'll learn
Learn about PowerShell, Automation, scripting, Creating HTML Reporting with Color format!...
This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily develop PowerShell script at the end of course.
Health Check Report for SQL server
Working with multiple of Server for Creating HTML Report
Requirements
Learn HTML Healthcheck Report using PowerShell Scripting for SQL Server Database Administrator and fulfill their own dream for automation
Description
In this course you will get in depth knowledge for creating HTML Report. You will learn how to Create HTML Health check for SQL Server Daily DBA Task with the help of PowerShell and HTML. At the end of this Course you will able to develop the PowerShell Script for HTML Report and you can send the report as body or attachment. Basically this course has been divided in to multiple of session which include the Basic and advance coding of PowerShell. Even you will find the other additional session, Which will be the subcategory of the main course. For Sub-category you have to go through each module of the video. After completing the Each video session you will able to download the PowerShell Script and HTML Report. I am going to discuss each and every Scripts which has beet attached. I will be frequently uploading the video and you will get life time access to this curse. For doubt clarification I will provide all details at the end of this course so you can connect with me. This course has been designed in such a way that any one having the basic knowledge of SQL DBA and PowerShell they can easy learn and develop the script using PowerShell.
Overview
Section 1: Section 1
Lecture 1 HTML Basic - 1
Section 2: Section 2
Lecture 2 HTML Basic-2
Section 3: Section 3
Lecture 3 HTML Basic (ID and Class)
Section 4: Section 4
Lecture 4 HTML Table
Section 5: Section 5
Lecture 5 Colspan
Section 6: Section 6
Lecture 6 Rowspan in HTML
Section 7: Section 7
Lecture 7 Special Style for One Table
Section 8: Section 8
Lecture 8 What is ConvertTo-HTML in Powershell
Section 9: Section 9
Lecture 9 SQL Server Failed job HTML Report
Lecture 10 How to add new column to HTML table - Adding alert and comment as Column
Lecture 11 Color formatting for HTML Report
Lecture 12 How to send SQL Job Status Report as HTML body in email
Lecture 13 How to Send email from PowerShell
Section 10: Section 10
Lecture 14 Create HTML Report for services running on computer
Section 11: Section 11
Lecture 15 Creating HTML Disk Space Report
Lecture 16 How to Fixed , Divided by Zero Error and Adding DriveType Information
Section 12: Section 12
Lecture 17 HTML Report for Full Back if its not happening from 12 hr
Lecture 18 Full Backup Report for Multiple of Servers in same HTML file
Section 13: Section 13 - HealthCheck Report
Lecture 19 V1-Basic HealhCheck Report - Basic- 1
Lecture 20 V1-Basic HealhCheck Report - Basic- 2
Lecture 21 V2-Basic HealhCheck Report - Adding Try and Catch
Lecture 22 V3-Basic HealhCheck Report - Adding Database Information
Lecture 23 V4-Basic HealhCheck Report - Adding Function for SQL Login Information
Lecture 24 V5-Basic HealhCheck Report - Checking login with sa permission
Lecture 25 V6-Basic HealhCheck Report - Adding SQLJobOwner Information to Healthcheck Repor
Lecture 26 V7-Basic HealhCheck Report - Adding Status of SQLServiceAccount to Healthcheck R
Section 14: Section 14
Lecture 27 V8-Basic HealhCheck Report - Adding SQL Sever Global Configuration Parameters to
Lecture 28 V9-Basic HealhCheck Report - Adding Blocking Information with color
Lecture 29 V10-Basic HealhCheck Report - Adding Disk Space Details to healthcheck Report
Lecture 30 V11-Basic HealhCheck Report - Adding SQL Server job last run Status
Lecture 31 V12-Basic HealhCheck Report - Adding Backup Information to HealthCheck Report
Lecture 32 V13-Basic HealhCheck Report - Adding Performance Counter
Lecture 33 V14-Healthcheck-Sending Report as HTML body or Attachement
Learn Creating HTML Report and automate Using PowerShell for SQL server DBA daily task
