Pioneering with PowerShell

  • Comments posted to this topic are about the item Pioneering with PowerShell

    Best wishes,
    Phil Factor

  • Who needs the unlovely VBScript anymore?

    What was so unlovely about it? It worked just fine. Since most front-end developers are familiar with C# or Java, it makes it easier for them but PowerShell is just a different way of doing the same thing you could do in VBS.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Huge push for PowerShell and yet PASS completely screwed the pooch with the lack of PowerShell sessions at this years Summit with a precon, a spotlight and another regular session.



    Shamless self promotion - read my blog http://sirsql.net

  • Hail The Powershell

    Nice and to the point editorial

    I was there in Teched, attended all the powershell conferences

    I am still in the information-overload stage, so much good information

    Also got exposed to F# and the Kanban!!!

    Now I just need to brush up my Klingon!!!

  • So few PASS sessions on PowerShell? That is a great shame.

    Jeff, if you think that PowerShell is equivelent to VBA/VBScript, then you haven't tried PowerShell hard enough. Sure, you can convert from VB to PowerShell, but PowerShell does so much more...

    Best wishes,
    Phil Factor

  • Phil Factor (6/24/2012)


    Jeff, if you think that PowerShell is equivelent to VBA/VBScript, then you haven't tried PowerShell hard enough. Sure, you can convert from VB to PowerShell, but PowerShell does so much more...

    Agreed. I find Powershell to be surprisingly set-oriented for such a procedural/operational language. In many ways it's the most SQL-like language Microsoft has ever released to production. (besides actual SQL of course... 😀 )

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • I will admit that it's nice to be able to return a result set just by using a "SELECT" in a WMI query in power shell.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Good article. I would appreciate it if someone could bring me up to speed on this point: Does PowerShell itself (v 3.0?), or a third-party product, offer PowerShell debugging capability that is the equivalent of that found in the VS.NET IDE for VB.NET\C# ? (I regard such debugging capability as essential, not just a nice feature.)

    Barkingdog

  • Take a look at the PS development tools from Idera, Quest and Sapien.



    Shamless self promotion - read my blog http://sirsql.net

  • PowerGUI provides some pretty good tools, FYI.

  • I find Powershell can do almost everything. I just try to generate PDF or excel from Reporting service via web service call from Powershell.

    I use Sql agent to run powershell on production. How do you usually scheudle PowerShell script? What are pros and cons?

  • Nicholas Cain (6/23/2012)


    Huge push for PowerShell and yet PASS completely screwed the pooch with the lack of PowerShell sessions at this years Summit with a precon, a spotlight and another regular session.

    Yes - there could have been more.

    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

  • RBarryYoung (6/24/2012)


    Phil Factor (6/24/2012)


    Jeff, if you think that PowerShell is equivelent to VBA/VBScript, then you haven't tried PowerShell hard enough. Sure, you can convert from VB to PowerShell, but PowerShell does so much more...

    Agreed. I find Powershell to be surprisingly set-oriented for such a procedural/operational language. In many ways it's the most SQL-like language Microsoft has ever released to production. (besides actual SQL of course... 😀 )

    For the most SQL-like language released by Redmond, try SCOPE.

  • Not having worked with it, I did read some articles last year and was totally horrified by the language specifics and couldn't phantom somone getting language basics so wrong! A language needs to be precise and absolutely clear in its meaning, yes even scripting languages, but powershell code can be interpreted in many ways, most of them seem reasonable and useful in some situations, but only one is actually what it will do. That in itself constitutes a major fail I will argue here (I feel the same about perl for example)

    I would absolutely HATE to be forced to use such languages, but for some reason some people adore cryptic and mystic languages and confuse them for powerful. I always seen this as soem sort of cult factor!

    The mystic part will disapear if you know all the exact details and pay extreme attention to every letter, but at that point a scripting lanuage in my view already has failed!

  • My main wish is that instead of creating YAPL (Yet Another Programming Language), Redmond could have leveraged a non-cryptic scripting language like Python. I enjoy learning, but the number of different language I need to accomplish my normal daily tasks is ridiculous!

Viewing 15 posts - 1 through 15 (of 17 total)

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