PowerShell for the DBA

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

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

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