April 8, 2009 at 5:22 am
hi all,
why we should use windows power shell?
please provide the references for power shell.
thanks,
🙂
April 8, 2009 at 5:46 am
vrabhadram (4/8/2009)
hi all,why we should use windows power shell?
please provide the references for power shell.
thanks,
For automating tasks, its one of the powerful command language more like a python I would say better than a python.
this:
http://72.32.35.89/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/
April 8, 2009 at 5:58 am
http://www.microsoft.com/windowsserver2003/technologies/management/powershell/default.mspx
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
April 8, 2009 at 11:43 am
I as the same question in a few months ago. ..When i start to use and understand a litte i see it´s a powerfull command shell.
My automated and monitoring scripts to my sql server servers is almost them PS scripts. Its very ease and productive.
I start whith this read..when i did the same question, someone in this site shows me this
Now...i´m love with powershell..
Look at the other thread you open..about run various .sql...i show something using powershell. In 5 lines we do this...with more 4 or 5 command lines this script execute all.sql in all databases in all sql server servers.
One of my daily monitoring ... how are my linked servers..its ok or not .
So i use one script in powershell to do this, in all linkerd servers and all sql server servers. this script run at 6:00 AM and every morning i came in my job and i did a dashboard report with my informations (failure jobs, linked servers with problem, services out..etc) a.. this information in all servers using powershell.
The goal to use with sql server is learn about SMO and uses with XML too.
Look at the script to test link servers, it´s very easy..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply