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/5/f/4/2/0/5f42069ea6d4982b297edbc8ddecd4ab31ee6411-correct.png" />

Update Variables

09, Oct Klaas

In this article I demonstrate how to update a collection of variables. It's a bit more complex than you may think, but not hard at all.

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/a/3/8/e/0a38eaa6f97fa585709478590db30edd5ff014fb-budir.png" />

Measure twice

31, Jul Klaas

In this article I demonstrate the difference between using the InputObject parameter in the Measure-Object command and piping the same object into it. We get different results, and this is the explanation.

Continue Reading...

<img alt="" src="/images/e/2/c/0/8/e2c08ea378f4f90443e8b2189ce22d9fcebc7251-match.png" />

Regexp with PowerShell, more than a match

18, Jul Klaas

In this article I show where regular expressions can appear in PowerShell. You probably know you can use a regexp in -match, but there are some other interesting uses.

Continue Reading...