Danh mục
Development
Web Development Data Storage Git Automation Database Design Web Scraping
Business
Business Analysis Communication Project Management Sales Forecasting Business Strategy Operations Management Human Resources Oil and Gas Industry
Finance & Accounting
IT & Software
Office Productivity
SAP Word Excel PowerPoint Excel VBA SharePoint
Personal Development
Persuasion Notion Workspace Mind Mapping
Design
Design Sketching Typography Game Design Digital Art zBrush 3D Animation
Marketing
SEO Marketing Strategy YouTube Marketing Digital Marketing Facebook Marketing Growth Hacking Twitter Marketing Instagram Marketing
Lifestyle
Beer Brewing Beauty Home Repair Energy Healing Bartending Leather Crafting Makeup Artistry Hypnotherapy
Music
Piano Guitar Singing Music Production Acoustic Guitar Fingerstyle Guitar Music Theory Bass Guitar
Duocmmo Tedu Tin học văn phòng Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Other IT & Software
Automation
PowerShell For HTML or Health Check Report for SQL DBA Task

PowerShell For HTML or Health Check Report for SQL DBA Task

Loại khoá học: Other IT & Software

SQL Server HTML Report for DBA, Automation HealthCheck Report for SQL server using PowerShell, SQL server database admin

image
50.000 VND
110 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

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. 


Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

14 sections

Section 1:

1 lectures
HTML Basic - 1
01:08:14

Section 2:

1 lectures
HTML Basic-2
46:48

Section 3:

1 lectures
HTML Basic (ID and Class)
28:47

Section 4:

1 lectures
HTML Table
19:41

Section 5:

1 lectures
Colspan
05:42

Section 6:

1 lectures
Rowspan in HTML
08:14

Section 7:

1 lectures
Special Style for One Table
03:39

Section 8:

1 lectures
What is ConvertTo-HTML in Powershell
53:56

Section 9:

5 lectures
SQL Server Failed job HTML Report
34:50
How to add new column to HTML table - Adding alert and comment as Column
10:55
Color formatting for HTML Report
25:19
How to send SQL Job Status Report as HTML body in email
11:48
How to Send email from PowerShell
36:22

Section 10:

1 lectures
Create HTML Report for services running on computer
46:10

Section 11:

2 lectures
Creating HTML Disk Space Report
01:03:55
How to Fixed , Divided by Zero Error and Adding DriveType Information
15:39

Section 12 :

2 lectures
HTML Report for Full Back if its not happening from 12 hr
38:00
Full Backup Report for Multiple of Servers in same HTML file
26:25

Section 13 - HealthCheck Report

8 lectures
V1-Basic HealhCheck Report - Basic- 1
45:53
V1-Basic HealhCheck Report - Basic- 2
57:59
V2-Basic HealhCheck Report - Adding Try and Catch
29:21
V3-Basic HealhCheck Report - Adding Database Information
26:20
V4-Basic HealhCheck Report - Adding Function for SQL Login Information
16:19
V5-Basic HealhCheck Report - Checking login with sa permission
16:54
V6-Basic HealhCheck Report - Adding SQLJobOwner Information to Healthcheck Repor
11:13
V7-Basic HealhCheck Report - Adding Status of SQLServiceAccount to Healthcheck R
11:15

Section 14 :

7 lectures
V8-Basic HealhCheck Report - Adding SQL Sever Global Configuration Parameters to
10:34
V9-Basic HealhCheck Report - Adding Blocking Information with color
13:37
V10-Basic HealhCheck Report - Adding Disk Space Details to healthcheck Report
24:13
V11-Basic HealhCheck Report - Adding SQL Server job last run Status
10:57
V12-Basic HealhCheck Report - Adding Backup Information to HealthCheck Report
14:26
V13-Basic HealhCheck Report - Adding Performance Counter
19:16
V14-Healthcheck-Sending Report as HTML body or Attachement
07:00

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

AWS EKS Kubernetes-Masterclass | DevOps, Microservices

AWS EKS Kubernetes-Masterclass | DevOps, Microservices

120 VND
50.000 VND
Embedded Linux Using Yocto Part 2

Embedded Linux Using Yocto Part 2

80 VND
50.000 VND
Embedded Linux using Yocto Part 3

Embedded Linux using Yocto Part 3

85 VND
50.000 VND
Embedded Linux using Yocto

Embedded Linux using Yocto

80 VND
50.000 VND
Viết ứng dụng bán hàng với Java Springboot/API và Angular

Viết ứng dụng bán hàng với Java Springboot/API và Angular

25 VND
50.000 VND
An ninh mạng cho người mới bắt đầu

An ninh mạng cho người mới bắt đầu

25 VND
50.000 VND
An Entry-Level Course on Analog and Digital Microelectronics

An Entry-Level Course on Analog and Digital Microelectronics

75 VND
50.000 VND
DATA CENTER - TRUNG TÂM DỮ LIỆU: HỆ THỐNG ĐIỆN.03 - CB08

DATA CENTER - TRUNG TÂM DỮ LIỆU: HỆ THỐNG ĐIỆN.03 - CB08

30 VND
50.000 VND
Starting an ISP with MikroTik

Starting an ISP with MikroTik

25 VND
50.000 VND
MikroTik Security Engineer with LABS

MikroTik Security Engineer with LABS

25 VND
50.000 VND
MikroTik Traffic Control with LABS

MikroTik Traffic Control with LABS

25 VND
50.000 VND
MikroTik Routing Engineer with LABS

MikroTik Routing Engineer with LABS

25 VND
50.000 VND
ISP Core Network Setup with MikroTik

ISP Core Network Setup with MikroTik

25 VND
50.000 VND
EF Core and .NET 6: Zero to Pro with ASP NET Web Api

EF Core and .NET 6: Zero to Pro with ASP NET Web Api

25 VND
50.000 VND
DevOps Beginners to Advanced with Projects

DevOps Beginners to Advanced with Projects

120 VND
50.000 VND
[2023] Master Spring MVC with Java for Beginners

[2023] Master Spring MVC with Java for Beginners

25 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi