• pkrudysz (12/29/2011)


    ALZDBA (12/29/2011)


    - setting startup parameters if your service account doesn't have local sysadmin at windows level.

    - Cool.

    ALZDBA (12/29/2011)


    - granting auth at windows level ( e.g. to push backup files to a safe zone )

    - xp_cmdshell

    ALZDBA (12/29/2011)


    - are you using SMO to configure sqlserver things ?

    - No, no need. I use sqlserver (SSMS/T-SQL) to configure sqlserver things

    Of course you can do it all manually, time and again.

    You are correct, xp_cmdshell can take you a long way.

    Powershell only provides the means to hook up to more than just what's available in DOS (xp_cmdshell) and vbscript.

    That means for many systems people, that don't program e.g. c#.net, .. they have to learn only one language syntax, hook up to their target namespace and use that software's proper methodes to configure whatever needed.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me