Episode 95-Josh Jones From the CS Techcast Talks PowerShell and SQL
Listen to this Episode
Audio available
A Podcast about Windows PowerShell.
Listen:
In This Episode
Tonight on the PowerScripting Podcast we talk to Josh Jones from the CS TechcastÂ
News **
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 and see why PowerShell and Quest Power GUI are the ultimate Windows management tools. *
Â
-
[PowerWF Beta 3 dropped this month](http://blog.powerwf.com/post/276676707/powerwf-studio-beta-r3-released); imports PowerShell Modules & Snapins into the toolbar
-
[It's a PowerShell Christmas!](http://dnn.itprotoronto.ca/Blogs/tabid/62/EntryId/80/Powershell-Christmas-Tree-ndash-Again.aspx)
-
[PoshBoard 2.5 is now on codeplex](http://www.poshboard.com/index.php?option=com_content&view=article&id=33:poshboard-25-video-introduction&catid=1:poshboard&Itemid=19&lang=en)
-
[Quest's PowerPack Challenge winners are up](http://dmitrysotnikov.wordpress.com/2009/12/02/winners-of-powerpack-challenge-2009/)
Interview
*This segment is brought to you by *[*SAPIEN Technologies*](http://sapien.com/)*.*
Links
-
[http://www.cstechcast.com](http://www.cstechcast.com/)
Questions
-
##Josh, did you go to school for DB admin, or was it learned on the job?
-
jtruman0917: ## Josh what are your feelings about SSRS? Â Do you use it?
-
AaronHoover: ## Josh, is most of your stuff back-end? Â Any front-end design? Â If so, what tools?
-
jtruman0917: ## so for your reports do you code your own SP's and attach the report to them?
-
AaronHoover: ## Josh, is most of your stuff back-end? Â Any front-end design? Â If so, what tools?
-
jtruman0917: ## Have you ever had to support applications that implemented sql queries on the fly
-
jtruman0917: ## is it like Group Policy Manager?
SuperHero/Power - Wizardry (Warlock)
Resources
-
Tutorial:Â [PowerWF and PowerCLI](http://blog.powerwf.com/post/221107418/tutorial-leveraging-powershell-and-powercli)
-
Virtu-Al's [PowerCLI quick reference guide](http://www.virtu-al.net/2009/12/04/powercli-quick-reference-guide/) updated for 4.0 U1
Tips
Please support our sponsor ServerFault.com, the ultimate Q&A site for system administrators!
-
JSON in PowerShell from [Jaykul](http://huddledmasses.org/json-from-powershell-but-why/) and [Hal](http://poshcode.org/1529)
-
[Creating new objects with a hashtable](http://blogs.msdn.com/powershell/archive/2009/12/05/new-object-psobject-property-hashtable.aspx)Â (v2)
-
PoshCode helper script for even more new-object goodness:Â [New-PSOCustomObject](http://poshcode.org/1543)
-
[Unblock a file in PowerShell](http://stackoverflow.com/questions/1617509/unblock-a-file-with-powershell)