Pioneering with PowerShell

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Pioneering with PowerShell

18 posts, Page 1 of 2

1 2 »»

Pioneering with PowerShell

Rate Topic

Display Mode

Topic Options

Author

Message

Phil Factor

Posted Saturday, June 23, 2012 12:08 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:10 AM
Points: 535, Visits: 2,295

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

Best wishes,

Phil Factor
Simple Talk

Post #1320274

Jeff Moden

Posted Saturday, June 23, 2012 3:10 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1320291

Nicholas Cain

Posted Saturday, June 23, 2012 3:35 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, June 07, 2013 12:02 PM
Points: 2,007, Visits: 6,043

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

Post #1320301

artilugio

Posted Saturday, June 23, 2012 7:29 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 10:20 AM
Points: 92, Visits: 111

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!!!

Post #1320312

Phil Factor

Posted Sunday, June 24, 2012 3:51 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:10 AM
Points: 535, Visits: 2,295

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
Simple Talk

Post #1320337

RBarryYoung

Posted Sunday, June 24, 2012 7:36 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

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... BigGrin

)

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #1320351

Jeff Moden

Posted Sunday, June 24, 2012 1:24 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

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

Post #1320383

Barkingdog

Posted Sunday, June 24, 2012 2:21 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 855, Visits: 803

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

Post #1320387