Automate Your Daily Database Checks with PowerShell
I've done this presentation since the good old days of PowerShell v1.0 It has evolved throughout the years, incorporating new tools to accomplish one goal: automate daily database checks using PowerShell.
You'll get a glimpse of how I do health checks for large SQL Server Always On Availability Groups at the end of the video.
References:
dbatools - https://dbatools.io/
dbachecks - https://dbachecks.readthedocs.io/