Where Do I Start with PowerShell?


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:


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/


Powershellcommunity.org: http://www.powershellcommunity.org/

PowerShell.com: http://powershell.com/cs/


Master-PowerShell with Dr.Tobias Weltner: http://powershell.com/cs/blogs/ebook/


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


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


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.

This entry was posted in PowerShell and tagged . Bookmark the permalink.

10 Responses to Where Do I Start with PowerShell?

  1. Keith Mescha says:

    Thanks, I had like 20 tabs open in my browser, now I just need one. Your blog.

  2. Buck Woody says:

    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

  3. Jeffrey Snover says:

    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

  4. Pingback: What We’re Reading: May 7th 2010 | Brent Ozar - Too Much Information

  5. Jen McCown says:

    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!

    • David Levy says:

      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.

  6. stefbauer says:

    GREAT collection! Thanks for pulling it together!

  7. Pingback: Friday Funtime: Contest, Powershell, Preview! « SQL Awesomesauce

  8. Pingback: PoSHpiphany – I’ve seen the light….and it is Powershell « mikeSQL's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.