PowerShell for the DBA

<img alt="" src="/images/5/2/c/6/3/52c638cdd61e486ae1bf24aa434edc0019c78ce8-split.png" />

Show me my back-up config

14, Nov Klaas

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

<img alt="" src="/images/f/0/8/e/6/f08e686e779478ce14c8cc4b233b966fdf33f5ba-dbnameunderscore.png" />

Put my backup files back

14, Aug Klaas

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

<img alt="" src="/images/0/6/3/c/7/063c716b36a76da976c538b0102848f3cb8520e0-compare1.png" />

Check IFI with PowerShell

04, Jul Klaas

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

<img alt="" src="/images/5/a/5/2/8/5a52853550f7b44ed7b046a95435705bf1f1173c-menu.png" />

Wrapper script for dbatools computerinfo

12, Jun Klaas

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

Continue Reading...

<img alt="" src="/images/c/8/3/1/3/c83130b677ae1fec1244e102de2294516950123c-mail.png" />

Mail me the backups results

05, Jun Klaas

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