PowerShell for the DBA

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.

Continue Reading...

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.

Continue Reading...

In this article I show how to write a wrapper script to swiftly call a selection of dbatools commands on the computerlevel.

Continue Reading...

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.

Continue Reading...