Episode 111 – Buck Woody from Microsoft on SQL Server and PowerShell

A Podcast about Windows PowerShell.
Listen:

News

• MVP Richard Siddaway has a new Codeplex project: PowerShell Admin Modules. His blog post talks about some of the features for working with network shares.
• MVP Shay Levy has a new project on MSDN Code Gallery titled PSClientManager that allows you to work with Windows 7 features.
• 2010 Scripting Games are upon us!
• User Group News
  • New York City – May 10th
  • Syracuse – May 11th
  • SE Michigan – May 11th
  • Tampa – May 13th
  • Central Ohio – May 13th
  • Atlanta - May 18th
• Local conferences
  • @SQLVariant is speaking at SQL Saturday in Jacksonville on May 8th. He is also going to present the same talk on Geek Speak in case you can’t make it to J-ville.
  • Codestock in Knoxville TN happens June 25th & 26th and there will be 4 PowerShell sessions including some from Hal and @SQLVariant.

Interview

Before you acquire power, you must acquire knowledge – and Quest Software has what you need! In Jeffery Hicks’ e-book, “Managing Active Directory with Windows PowerShell,” learn how PowerShell helps you master local accounts and groups, password management, security and permissions and much, much more. You’ll also learn about the PowerShell extras and out-of-the-box features that will help you control Active Directory. Don’t wait – visit quest.com/powershellbook to register for your free copy or quest.com/powerguipro and see why PowerShell and Quest PowerGUI are the ultimate Windows management tools.

Links

• Carpe Datum (Buck’s work blog)
• Buckwoody.com
• Pain of the Week: The SysAdmin’s Guide to SQL Server
• http://blogs.technet.com/heyscriptingguy/archive/2009/05/29/how-can-i-use-windows-powershell-to-run-daily-checks-on-my-sql-server-2008-servers.aspx
• http://blogs.technet.com/heyscriptingguy/archive/2009/05/27/how-does-windows-powershell-make-it-easier-to-work-with-sql-server-2008.aspx
• http://www.sqldownunder.com/SQLDownUnderShow41BuckWoodyPowershell/tabid/442/Default.aspx

Questions

• LaerteJunior: ## Buck : when you came in Brazil, spoke about the powershell TechEd Brazil. Today I no longer see MS talk about powershell. Even the Host Sql Server is still 1.0. PowerShell is forgotten?

Hero/Power –

• Buckaroo Banzai

• Frank-Peter points us to ScriptBox, a script repository with over 1300 PowerShell scripts.
• PowerShell Transactions 
• Using STA to continue in your console session while a from is loaded
• Dmitry has posted version 2 of his SharePoint 2010 quick reference.
• Tech brief on PowerGUI Pro

• Jeff Hicks talks about adding verbosity to your scripts