In this article I want to talk about managing a SQL 2012 Server with PowerShell from a remote computer. As I’ve mentioned in an earlier blog post PowerShell is becoming more and more important in the day to day task of a system administrator.
I am using PowerShell ISE as scripting application. It is a simple scripting tool but it does everything I need at this time to make my PowerShell work easy.
$fldr = "C:\users\robin\Documents\PowerShell\data" $credential = Get-Credential $credential.Password | ConvertFrom-SecureString | Set-Content "$fldr\adminpassword.bin" $password = Get-Content "$fldr\adminpassword.bin" | ConvertTo-SecureString $cred = New-Object System.Management.Automation.PSCredential("contoso\adminrobin", $password) New-PSSession -Name SQL -ComputerName sql01.contoso.com -Credential $cred Enter-PSSession -Name SQL