Powershell - Any Reason NOT to Install ?

  • I have a mix of 2005 & 2008 SQL servers, but only 1 has Powershell installed. I would like to build some utilities using it. For instance, an alert when disk space is low.

    Are there any dangers to installing Powershell on our Windows 2003 R2 Servers running SQL ?

  • No real risks as long as you choose the correct Execution Policy for your environment.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • we are not facing any issues... So I believe it should be fine as long as you know what you are doing...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • BuntyBoy (2/27/2013)


    we are not facing any issues... So I believe it should be fine as long as you know what you are doing...

    Big problem there ! :blush:

  • I highly recommend this book.

    Learn Windows PowerShell 3 in a Month of Lunches

    It goes through the Execution Policy choice, as well as Remote Management. You'll be scripting in no time.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • I'd install it. I'm a novice at it but there is some power to the tool.

    You could also read the month long blog series on PoSH here.

    http://blog.waynesheffield.com/wayne/a-month-of-powershell/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply