Introduction
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I threw the question out to the SQL Community on Twitter via #SqlHelp. The response was so overwhelming that I decided I at least owed it to the SQL Community to get it all written down.
Thank you to everyone who supplied a link, you are what keeps the SQL Community great!
So here is everything that came in broken out by category:
Blogs
Aaron Nelson: http://sqlvariant.com/wordpress/
Aaron Nelson – PowerShell Links: http://sqlvariant.com/wordpress/index.php/powershell-links/
Aaron Nelson – Getting Started with PowerShell: http://sqlvariant.com/wordpress/index.php/2010/02/sqlserversqldatabasestables-dir/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Sqlvariations+%28SQLvariations%3A+SQL+Server%2C+a+little+PowerShell%2C+maybe+some+Hyper-V%29
Aaron Nelson – Get More Done With SQLPSX: http://sqlvariant.com/wordpress/index.php/2010/02/get-more-done-with-sqlpsx/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Sqlvariations+%28SQLvariations%3A+SQL+Server%2C+a+little+PowerShell%2C+maybe+some+Hyper-V%29
Buck Woody – Carpe Datum: http://blogs.msdn.com/buckwoody/archive/tags/PowerShell/default.aspx
Buck Woody – InformIt: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=253&rll=1
Buck Woody – Intro to PowerShell Series: http://blogs.technet.com/heyscriptingguy/archive/2009/05/27/how-does-windows-powershell-make-it-easier-to-work-with-sql-server-2008.aspx
Hey, Scripting Guy! Blog: http://blogs.technet.com/heyscriptingguy/archive/tags/getting+started/default.aspx
Laerte Junior – Great Practical Examples on SimpleTalk.com: http://www.simple-talk.com/author/laerte-junior/
Laerte Junior – $hell Your Experience (Portuguese): http://laertejuniordba.spaces.live.com/
Windows PowerShell Blog: http://blogs.msdn.com/powershell/
Community
Powershellcommunity.org: http://www.powershellcommunity.org/
PowerShell.com: http://powershell.com/cs/
eBooks
Master-PowerShell with Dr.Tobias Weltner: http://powershell.com/cs/blogs/ebook/
TechNet
Task-Based Guide to PowerShell: http://technet.microsoft.com/en-us/library/ee332526.aspx
PowerShell Script Center: http://technet.microsoft.com/en-us/scriptcenter/dd742419.aspx
Script Center: http://technet.microsoft.com/en-us/scriptcenter/default.aspx
Windows PowerShell: Survival Guide: http://social.technet.microsoft.com/wiki/contents/articles/windows-powershell-survival-guide.aspx
Applications / GUIs
PowerGUI: http://powergui.org/index.jspa
Videos
Midnight DBA PowerShell Videos: http://midnightdba.itbookworm.com/Admin.aspx
White Papers
Understanding and Using PowerShell Support in SQL Server 2008: http://msdn.microsoft.com/en-us/library/dd938892.aspx
Conclusion
So there you have it, a pretty substantial list of resources to get started in PowerShell.These all look like great resources and I can see I have a ton of reading to do.
Thanks, I had like 20 tabs open in my browser, now I just need one. Your blog.
I have lots of stuff on this site as well: http://tinyurl.com/2du5ce4
Did a four-part series on getting started at the Scripting Guys: http://tinyurl.com/26agcyy
And did a full series on it for the DBA at InformIT starting here: http://tinyurl.com/276m82y
This internet thing is pretty useful! 🙂
Jeffrey Snover [MSFT]
Distinguished Engineer
Visit the Windows PowerShell Team blog at: http://blogs.msdn.com/PowerShell
Visit the Windows PowerShell ScriptCenter at: http://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx
It really is. (Warning: Deep Thoughts) You have me asking what we would do without internet. The world would truly be a different place.
Hi Dave,
Not sure if this is offsides, but I’m a big fan of Sean’s PS videos – especially the beginner’s guide – on our site MidnightDBA.com. I didn’t see any vids on the list, so I thought I’d toss that into the mix.
Thanks for compiling all these links!
-Jen
Not offsides at all. The idea is to get the information out there. I have a feeling I will get more suggestions today so I will update the post tonight.
GREAT collection! Thanks for pulling it together!