PASS 2008 Conference - Day Five - Carpe Datum - Site Home

PASS 2008 Conference - Day Five

Rate This

BuckWoody

21 Nov 2008 8:01 PM

Comments 8

Today was the final day of the conference, but I had a packed house for our discussion on PowerShell and SQL Server. I wanted to blog about one concept I covered in the demo: Why would I use PowerShell when I have SSIS, stored procs, batch files and other mechanisms?

I submit the following reasons:

PowerShell is a shell, so you get immediate feedback
PowerShell is kind of a language, so you can work in batches later if you want (writing scripts)
PowerShell makes working with HTML output easy
PowerShell makes working with XML easy
PowerShell makes working with WMI easy
PowerShell can talk to Windows things
PowerShell can talk to Exchange things
PowerShell can talk to SharePoint things
PowerShell can talk to .NET things (it uses .NET as well)
PowerShell can talk to (insert Microsoft technology here) things
PowerShell is fairly easy to learn
PowerShell scripts are fairly easy to read
PowerShell can look like Unix/Perl/DOS/whatever

OK - go off and try it. It isn't hard, it works well, and it makes your work easer.

PowerShell, Conferences

Leave a Comment

Name
Comment
Please add 7 and 1 and type the answer here:
Post

Comments

PASS 2008 Conference - Day Five | MS Tech News

21 Nov 2008 8:15 PM

PingBack from http://mstechnews.info/2008/11/pass-2008-conference-day-five/
BEACHDBA

24 Nov 2008 11:06 AM

This presentation was one of the highlights of the conference to me. Great combination of laughs and information. Your co-presenter's one word answers to the audience questions were all-time classics.
Tim Benninghoff

21 Dec 2008 10:14 PM

If your company is like mine, you are largely at the mercy of your software vendors as to when you'll
Tim Benninghoff

21 Dec 2008 10:17 PM

If your company is like mine, you are largely at the mercy of your software vendors as to when you'll
Tim Benninghoff

21 Dec 2008 10:21 PM

If your company is like mine, you are largely at the mercy of your software vendors as to when you'll
Douglas Laudenschlager

15 Jan 2009 6:34 PM

All the buzz over Windows PowerShell has aroused my curiosity, but it's hard to justify spending
Jamie Thomson

16 Jan 2009 1:55 AM

Buck,

I've done a comparison of the SSIS and Powershell pipelines here if you're interested

Talking Pipelines : SSIS and Powershell

(http://blogs.conchango.com/jamiethomson/archive/2008/12/09/talking-pipelines-ssis-and-powershell.aspx)

-Jamie
Wayne West

24 Jun 2010 11:52 AM

Buck, the link for the download isn't working, and you might want to put up a 404 redirect as I'm getting a page that looks like your site has been taken over by a link farm.

I've been wanting to get PowerShell working for me, but ran in to problems with certificate requirements blocking me from accessing servers remotely via PowerShell, so I'm sticking with Perl for now and looking in to Rodney Landrum's DBA Repository system.