One of my aims at the start of the year was to improve my Powershell and scripting skills. I run a few Google searches looking for resources and had plenty of results returned, but finding the ‘wheat from the chaff’ proved difficult. So I turned to twitter and asked the SQL community using the #SQLHELP hash tag. As an aside if you have a SQL problem and need an instance response and you can formulate a question in less than 140 characters add #sqlhelp to the end of your post and you’ll get a whole bunch of help…I digress. I got a whole heap of replies and I thought I would formulate the URLs in a txt document for future reference, then I realised I should post them on my blog so everyone can use them and here they are:

Useful Powershell URL's

http://midnightdba.itbookworm.com/VidPages/PowershellStartJobs/PowershellStartJobs.aspx

http://blogs.technet.com/heyscriptingguy/archive/2009/04/20/windows-powershell-an-introduction.aspx

http://www.databasejournal.com/features/mssql/article.php/3752866/Check-your-SQL-Server-using-Windows-PowerShell--Part-1.htm

http://sqlvariant.com/wordpress/index.php/category/powershell/

http://sqlvariant.com/wordpress/index.php/2010/02/get-more-done-with-sqlpsx/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+Sqlvariations+(SQLvariations:+SQL+Server,+a+little+PowerShell,+maybe+some+Hyper-V)

http://appdev.sqlpass.org/MeetingArchive/tabid/2005/Default.aspx

Thanks to Aaron Nelson @SQLvariant Chuck Boyce @chuckboycejr and Lorie Edwards @loriedwards for their replies and help.

If you know of a useful powershell resource that is not shown here please feel free to leave it in a comment.