Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Creating Custom PowerShell Objects

Summary: Use Windows PowerShell to create custom objects prior to data export. Microsoft Scripting Guy, Ed Wilson, is here. It is nice and cool this morning so I decided to walk over to the neighborhood coffee and tea shop to have a cup of tea. I can sit outside and enjoy the day. There is free wireless Internet, so I brought my Surface Pro&...

PowerTip: Use Graphical Tool to Create PowerShell Commands

Summary: Learn how to use a graphical tool to create Windows PowerShell commands.   (image)  How can I use Windows PowerShell so that I can point-and-click at options that are available for a using a particular cmdlet? (image)  Use the Show-Command cmdlet and select the parameters you need, for example: Show-Command -...

Use PowerShell to Fix Address Issues Prior to Export

Summary: Use Windows PowerShell to fix address issues prior to exporting the data to another database. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am listening to The Doors on my Zune HD, and sipping a very nice cup of tea. I used three spoons of Darjeeling tea, one spoon of lemon grass, one spoon of marshmallow root, one spoon...

Use PowerShell to Normalize Names Before Data Import

Summary: Use Windows PowerShell to normalize names before importing data. Microsoft Scripting Guy, Ed Wilson, is here. I have been reading Jane Austen Northanger Abbey this week in the evenings. I really love the way Jane Austen develops her characters. I also like some of the ways the characters express themselves. For example, “Give me...