October 6, 2008 at 7:18 am
Hy all, my english is very bad, so i will try...
I have read a lot about Powershell..and so far I have not seen a practical application using powershell. I have a lot of scripts with SMO, but why i use powershell if i can use a .VBS (and whit a .VBS i dont need to "installed" VBS...powershell needs)
Something like..
If you have 5 servers and you want to do "somenthing".....you can use powershell because....(it´s better, it´s easy, ..)
Please, a need help...
Thanks a lot
October 6, 2008 at 9:35 am
I wouldn't say you need to replace VBS with PowerShell. Different critters really.
I'm just getting started learning Powershell. It's installed automatically with SQL Server 2008 (just run sqlps.exe) and Windows Server 2008, so you would only have to install it on servers running older versions of SQL or the OS. Because so many different Microsoft devices are getting exposed through Powershell, it's going to make integration much easier. It's a pretty slick language. Just in trying it out I was able to put together a quick looping mechanism to simulate a load on a server using sqlcmd.exe within the PowerShell script.
I think it's more for admin types rather than programmers. It supplies them the type of functionality and control that UNIX shell scripts do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2008 at 9:56 am
October 6, 2008 at 3:07 pm
Why this SQL Server DBA is learning power shell[/url]
is a good read
October 6, 2008 at 3:29 pm
October 6, 2008 at 4:04 pm
Laerte POltronieri Junior (10/6/2008)
Thanks Jerry, it´s was exactly what i´m looking for...Practical applications
Exactly my thoughts after reading that (= something I can actually use at work in practice)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply