PowerShell for the DBA

In this article I talk about Performance Monitor and how to use it with PowerShell.
You get lots of useful information from PerfMon, but it can be cumbersome to work with. Using the GUI is easy but time consuming and not very portable. Here is a way to make it both easy and useful.

Continue Reading...

In this article I talk about the Best Practices Analyzer, which is delivered with your Windows OS.
Get an audit in seconds for free, with PowerShell.

Continue Reading...

In this article I show how to collect some information of interest on the environment you're working in.
You get to learn about your host, your profile, modules, execution policy and the likes.

Continue Reading...

In this article I show some methods to collect the computers you want to work with.
This is an essential step when moving towards automation and managing multiple computers or SQL Instances at the same time.

Continue Reading...

In this article I talk about an error I've been encountering with the root\Microsoft\SqlServer\ComputermanagementXX namespace since 2014.
It can save you some frustration, and maybe you can help making it go away. This post was previously published on my old blog on 2014-10-28.

Continue Reading...