Powershell For Html Or Health Check Report For Sql Dba Task
Published 11/2023
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.