Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 6 down vote favorite
4

I've been studying PowerShell and I've been (slowly) getting it into my day-to-day DBA tasks.

So far I've seen a bunch of disconnected PowerShell scripts for many disparate administration activities.

What I'd like to know is if there is an official (or recognizable) PowerShell scripts collection or repository that people usually go to for SQL Server PowerShell scripts for common DBA activities (something like Ola Hallengren's T-SQL scripts).

share|improve this question
Good question. I imagine there is a non-definitive list somewhere. If there's something you need to do in PS for DBA Admin, you can ask here as well I think. – JNK♦ Feb 14 '12 at 18:23
I've listed some resources and eBooks (not scripts per se, but definitely things that can help you write and understand them) toward the bottom of this post: sqlblog.com/blogs/aaron_bertrand/archive/2010/10/26/… – Aaron Bertrand♦ Feb 14 '12 at 19:51
add comment (requires an account with 50 reputation)

2 Answers

up vote 6 down vote accepted

I don't know that anyone has written something along the lines of Ola's script within PowerShell. I know that PowerShell scripts for SQL Server are slowly growing over at the TechnNet Script Center. Then MSSQLTips.com also has started publishing tips working with SQL Server and PowerShell.

Then you also have SQL Server PowerShell Extenstions project over on CodePlex. I don't guess you would consider it a repository but a good number of folks blog on how to use it and such. Some task within SQL Server are made much easier using SQLPSX.

I also tend to check out a few MVP blog sites that tend to focus on PowerShell scripts:
Allen White
Aaron Nelson
Sean McCown (MidnightDBA) (Click on the PowerShell tab for all the videos on the subject)

share|improve this answer
add comment (requires an account with 50 reputation)
up vote 0 down vote

There are a bunch of scripts on codeplex for database administration; I believe @sqlvariant has had a hand in writing them

share|improve this answer
Are you referring to something different on Codeplex from Shawn when he said: "Then you also have SQL Server PowerShell Extenstions project over on CodePlex"? – Jack Douglas♦ Feb 20 '12 at 10:01
add comment (requires an account with 50 reputation)

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.