PASS 2008 Conference - Day Five

Rate This
  • 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. 

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
  • PingBack from http://mstechnews.info/2008/11/pass-2008-conference-day-five/

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

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

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

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

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

  • 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

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

Page 1 of 1 (8 items)