Episode 46 - SQL PSX

A Podcast about Windows PowerShell.

Listen:

In This Episode

Today on the PowerScripting Podcast we interview Chad Miller, author of the SQL PSX project. And of course we'll throw in our other usual goodies.

News

 

This segment is brought to you by Idera.
Want to make Windows PowerShell easier than ever to learn and master? Checkout Idera's PowerShellPlus Professional Edition which is now available for download! The new version has vastly improved code completion and a slick interactive Learning Center. Go to www.idera.com/PodcastPeople to get your copy today.

Interview

Admin Script Editor (which recently received Windows IT Pro's top award) provides a true integrated scripting environment for PowerShell.  Advanced features include an integrated PowerShell debugger, advanced code generating tools for Active Directory, Databases, XML files and more.  Let's not forget about the exclusive PowerShell forms designer.  Come see for yourself-- Admin Script Editor v3.5 is availble for a 45 day trial at AdminScriptEditor.com.
We had a great interview with Chad Miller, the author of the SQL PSX  project on Codeplex. Below are some of the questions which were submitted by Ustream viewers.
  1. glnsize : ## is powershell speading throughout his it dept?
  2. mwjcomputing : ##How much of his day to day operations are managed using Powershell?
  3. glnsize : ## have you looked at V2 script cmdlets?
  4. mwjcomputing : ## When dealing with Auditors, do they have any objection to Powershell being the tool to gather the security information?
  5. stahler : ## ADO.NET through PowerShell or SQLCMD through PowerShell?
  6. meson : ## Any comments on a SQL database PSProvider?
  7. mwjcomputing : ## When gathering security information, does Powershell cause any performance hit on the database?
  8. glnsize : ##from a DBA perspective what is powershell missing?

Resources

This segment is brought to you by Quest:
Quest Software is offering Powerscripting Podcast listeners a free copy of Jeffery Hicks new book, Managing Active Directory with Windows PowerShell: TFM from Sapien Press. Visit quest.com/powerscripting to register for your copy, before they run out. While you’re there download their free graphical user interface, script editor and Active Directory commands.
About the Author

Jonathan Walz

Since March 2007, Jonathan Walz has been the co-host and technical brains for the PowerScripting Podcast. Conceived as a radio show for the PowerShell community, the podcast is the longest-lived PowerShell show in existence, and has featured dozens of weekly guests.