Pioneering with PowerShell

Question

Pioneering with PowerShell

Phil Factor

SSC-Insane

Points: 20244
More actions
June 23, 2012 at 12:08 pm

#143503

Comments posted to this topic are about the item Pioneering with PowerShell
Best wishes,
Phil Factor

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

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

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)

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 2

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

artilugio SSC-Addicted Points: 451 More actions · Answer 3

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

Phil Factor SSC-Insane Points: 20244 More actions · Answer 4

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

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]

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 6

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)

Barkingdog SSCoach Points: 18670 More actions · Answer 7

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

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 8

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

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

G_Burnett Grasshopper Points: 20 More actions · Answer 9

G_Burnett

Grasshopper

Points: 20

June 25, 2012 at 6:57 am

#1505029

PowerGUI provides some pretty good tools, FYI.

Kevin Mao SSC Rookie Points: 29 More actions · Answer 10

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?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

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

Revenant SSC-Forever Points: 42467 More actions · Answer 12

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.

peter-757102 SSCertifiable Points: 6877 More actions · Answer 13

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!

chrisn-585491 SSCoach Points: 16006 More actions · Answer 14

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!