• Rod at work (10/17/2012)


    I've been interested in PowerShell for a while now. I try to read every PowerShell article that comes along, unless it is a very long article, because I want to learn more. I work in a small shop with only a few SQL instances, but I think a skill like PowerShell could be useful, if I find a different position.

    Some of the things I've needed to do took much less time in Powershell than it would have taken to do manually on even five servers. I had to find out which of our servers had SSRS installed recently so I wrote a script that ran get-service for all of our servers and it went very quickly. Even with one server it's likely faster to open Powershell and type:

    get-service -ComputerName serverhere -Include ReportServer

    Than to open Computer management, go to services, and scroll down to where SSRS would be in the list. I would highly recommend starting to use Powershell for some of your tasks now and you'll likely find that some become easier once you know how to do them in Powershell. And for anything you do daily (such as check backups) it'll be well worth the effort.