I am wondering how is powershell used in SQL Server? I heard people saying that powershell makes a DBA's life easier. But I dont know how is powershell commonly used in SQL server. Can anyone provide me insights or links as to how powershell is being used in SQL Server?
closed as too broad by Shawn Melton, Kin Shah, RLF, James Anderson, mustaccio Apr 23 '16 at 14:57
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
So the main thing is that you can set these up to be dynamic. You wouldn't have to log into each instance to find out the settings. It does make it easier to perform a health check and just keep track of the lot. I used it for Parsing Excel documents to SQL server. This turned out to be very simple instead of converting it to csv documents and importing from there.
But what I would do is check into this site, it has a pretty good repository. A bit old though...
Additionally, Microsoft is making a huge amount of enhancements to powershell into SQL server. It was ignored previously as it was already a scripting language. Most people now are going into proper desired state configuration where you can spin up a SQL server instance with memory and all the settings you would like inside the SQL server instead of it just setting up the windows box and you needing to log into the SQL instance to run scripts. Pretty good post about it here.