PowerShell for the DBA

In this article I show how to extract all parameters from Ola Hallengren's maintenancesolution back-ups. We'll use some regular expressions again.

Continue Reading...

In this article I show how regular expressions can help us find SQL backup files. We'll use maintenancesolution.sql generated files to retrieve backup information. Beware the power of Objects in the pipeline!

Continue Reading...

In this article I show how to use the Where method with the Split option to quickly assign two variables. As an example we will check if our SQL Service Accounts have the Instant File Initialization Privilege.

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...