Powershell is EXCITING!!!<\/p>\n
Write a single line of text to a file – It takes whole mess of VB Script to do what Powershell will do in ONE LINE.<\/p>\n
“Book another holiday.” | out-file .\/myfile.txt -append<\/p>\n
List all the processes on the box – lots of VB code vs a single call to get-process in Powershell.<\/p>\n
get-service | out-file .\/myservices.txt<\/p>\n
get-processes<\/p>\n
psdrive – allows you to access the registry and sql server like you would any other drive.<\/p>\n
Concatenate string – “My name is: $z” – will concatenate irregardless of data type of $z<\/p>\n
$s = “localhost”<\/p>\n
ping $s<\/p>\n
$array = “server1”, “server2”, “server3”<\/p>\n
$array<\/p>\n
$array[2]<\/p>\n
get-service | get-member (or use gm)<\/p>\n
get-process | gm<\/p>\n
get-service | format-table (FT) <list of columns, comma delimited><\/p>\n
FL – format list<\/p>\n
get-service |%{$_.Kill()} – will kill all services and reboot your machine<\/p>\n
invoke-sqlcmd<\/p>\n
$server | %{invoke-sqlcmd -serverInstance $_ query “select * from ….”}<\/p>\n
$server | %{invoke-sqlcmd -serverInstance $_\u00a0 -Inputfile}<\/p>\n
dir | %{$_.script()} -out-file .\/mytables.txt<\/p>\n
Carrier method<\/p>\n","protected":false},"excerpt":{"rendered":"
Powershell is EXCITING!!! Write a single line of text to a file – It takes whole mess of VB Script to do what Powershell will do in ONE LINE. “Book another holiday.” | out-file .\/myfile.txt -append List all the processes … Continue reading