10 PowerShell Posts I Did in 2009

by Doug Finke on January 1, 2010

in Excel, ISE, Integrated Scripting Environment, Intellipad, MGrammar, Oslo, Pivot Tables, PowerBoots, PowerShell, Python, SQL Server Modeling, Try Python, WPF, trigrams, yUML

I had fun doing these PowerShell posts.

image 

Try PowerShell – An Interactive Tutorial

Michael Foord inspired this with his Try Python Silverlight application

How to Host PowerShell in a WPF Application

A How To video

PowerShell Out-ExcelPivotTable – Quickly Create Pivot Tables in Microsoft Excel

Automating Excel Pivot tables with PowerShell

PowerShell, An Exercise in Species Barcoding

Inspired by Peter Norvig’s (Director of research at Google) python version

PowerShell – Find the K most common words in a file

Based on Jon Bentley’s approach in “Little Languages”

PowerShell ISE-Cream – Alias Expansion

Uses PowerShell’s tokenizer to expand aliases like %, ? etc. into ForEach and Where

Update: Dynamic GUIs and the PowerShell Pipeline

How to inject GUIs into a PowerShell Pipeline

PowerShell yUML Workbench

yUML is a web service.  A How To using PowerShell to generate UML diagrams

PowerShell, PowerBoots and an Oslo DSL Grammar

Blending MGrammar and PowerShell

Creating and Displaying Trigrams with PowerShell

Based on Wolfram|Alphas Trigram visuals. Combines PowerShell and yUML

{ 2 comments… read them below or add one }

1 WebDevHobo 01.01.10 at 7:47 pm

I’m curious. What fields of work can Powershell be usefull for.

I realize that due to the sheer vastness of Powershell, it can probably do something for all possible fields, but what are the main intended fields.

For example, I’m mostly focussed on making websites in PHP. I have a C# training, but don’t really use it much in everyday life. What can powershell mean for me?

Also, what can Powershell do for the everday consumer?
I suppose anyone could write a ps1 file to do a simple task for them, kinda like a batch file, but beyond that, what is there left for the non-power-users?

2 Doug Finke 01.02.10 at 1:30 pm

Great question!

Stealing a quote from the creator of PowerShell, Jeffrey Snover, “PowerShell is digging us [Microsoft] out a 30 year hole”. Lot’s more work to do.

Since you work in PHP, PowerShell can’t help you directly. I use WordPress which uses MySQL and I use PowerShell to get stats and other things for my blog.

I believe PowerShell can be used in the same fields we see Ruby, Python, Groovy and Perl (and other dynamic, scripting languages) being used.

Jeffrey Snover posted his 2009 Scorecard PowerShell resolutions one of them being PowerShell and the Web.

Figure out the right mechanism for Rich Internet Applications (RIAs – e.g. Silverlight or AJAX apps) to talk to PowerShell across the web.
[We] Failed. Watch this space.

I believe everyday consumers will indirectly interact with PowerShell. For example, in Windows 7 Diagnostics, there are over 246 PowerShell scripts.

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>