In this article I show how to execute a T-SQL script with PowerShell and get objects back.
I've chosen the report subscriptions to demonstrate this.
In this article I show how to arrange the sql agent job executions on a Google timeline and send this as a HTML report attached to an e-mail.
In this article I show how to write a wrapper script to swiftly call a selection of dbatools commands on the computerlevel.
In this article I show how to send the backup states of all your databases in an e-mail. Of course, all automated with PowerShell.