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 3 ...
Summary: Learn how to use a graphical tool to create Windows PowerShell commands. How can I use Windows PowerShell so that I can point-and-click at options that are available for a using a particular cmdlet? Use the Show-Command cmdlet and select the parameters you need, for example: Show-Command -Name Get-Process...
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 of ...
Summary: Learn how to use Windows PowerShell to change the system time. The clock on my computer (running Windows 8.1) is 30 minutes slow. How can I use Windows PowerShell to move the system time up 30 minutes? Use the Set-Date cmdlet, create a TimeSpan object equal ...
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 but ...
