Episode 125 – Cooking Up Some PowerShell with Lee Holmes

September 13, 2010| PowerScripting Podcast

A Podcast about Windows PowerShell.
Listen:

In This Episode

Tonight on the PowerScripting Podcast we talk to Lee Holmes from the PowerShell team!

News

Execute commands and scripts from anywhere including the office and remote locations, as well as from a Web browser or smart phone with PowerGUI Pro from Quest Software. With the MobileShell feature, administrators can quickly run commands to troubleshoot problems or make changes, even when away from your desk! This gives teams more flexibility to work remotely while traveling, and to leverage admins from other offices in case of an emergency.
Â·Â Â Â Â Â Â Â Â Â Execute queries remotely to determine if services or processes are running
Â·Â Â Â Â Â Â Â Â Â Restart services, processes, or entire servers
Â·Â Â Â Â Â Â Â Â Â Check mailbox settings
Â·Â Â Â Â Â Â Â Â Â Unlock user accounts
Â·Â Â Â Â Â Â Â Â Â Reset passwords
Â·Â Â Â Â Â Â Â Â Â Run custom scripts
VisitÂ quest.com/powerguiproÂ and see why PowerShell and Quest PowerGUI are the ultimate Windows management tools.

Breaking news: Poshcode.org has been given permission to publish over 100 scripts from Lee Holmes PowerShell Cookbook!
New PowerShell, AD and PowerGui training
VMware releases Onyx 2.0
Ed Wilson will be presenting at SQL Saturday #46 in Raleigh 9/18/10

Interview

This segment is brought to you byÂ SAPIEN Technologies.

Notable Comments from the Chatroom

<SQLvariant-1> ##Right now we are seeing a lot of Connect items for SQL Server being closed as ‘fixed in next version’. Â Are any members of the PowerShell team working with the SQL folks in the various areas that would benefit from better PowerShell support like SSIS

<SQLvariant-1> ##Good Point. Â What are MSFT thoughts on how to make scheduling PoSh scripts a lot easier for everyone else (it’s simple for me, just schedule with SQL Agent)

<SQLvariant-1> ##Lee how did you pick what to include in the book. Â Did you have some recipies that you had to cut from the book?

<Jaykul> ##How excited are you that all your cookbook scripts are about to go up on PoshCode.org?

<Jaykul> you can tell him you heard a rumor I got permission 😉

<SQLvariant-1> ## I love the concept of Invoke-SQLCommand.ps1 but I work in an all Office 2010 environment and it doesn’t seem to work with Excel. Â Ist there a easy fix for that?

<Jaykul> ## Are there any of your scripts which you think really ought to be built-in?

Resources

This segment brought to you by ServerFault.com

Hal posted a Publish-File script useful for uploading files to a SharePoint document library
Andy Schneider started a How and Why of Learning PowerShell series
Converting CSV file or files into an Excel workbook
Boe Prox posted a link to a PowerCLI 4.1 cmdlet poster

Tips

Don Jones writes on using PowerShell to compare baseline configurations
A tip from The Scripting Guys on determining service launch order
How to hide CPU NX bits in VMware using PowerCLI (discussion)
PowerShell MVP Martin Zugec writes about using the new-webserviceproxy cmdlet with email address usernames