PowerShell: Create an HTML report from SQL

Humans need easy-to-read reports. Create an HTML file with tables for fast consumption.

Photo by David Clode on Unsplash

For an explanation of the health check queries, check out my previous article.

MS SQL Server Performance Checklist

Github repo for this article with PowerShell files.

GitHub - rchardptrsn/sql-check: Powershell scripts to run SQL health check and performance…

In this article, we will use PowerShell to:

• Run queries against a SQL Server 2022 database.
• Save the output of queries to tab-separated value text files.
• Construct an HTML report with tables based on the output files.

This was developed on:

• PSVersion 7.4.1 / Unix
• Mac OS Darwin 23.3.0 (Pre-M1 Macbook air)
• SQL Server 2022 Linux Docker Container. (See my article to set one up in less than 10 minutes)