Powershell Remoting with SQL Server

PowerShell, SQL Server 2008, SQLServerPedia Syndication
One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of these, you can basically┬ásend commands┬ásimultaneously┬áto a number of SQL Server instances. BUT... and there always seems to be one of those, there is a lot of work required to get this running right. I'm going to outline what I did recently to test the ability of PowerShell to begin administering my servers remotely. Hopefully this provide the basis for a checklist and a how-to. I'll update this post over time so that I get things right. Enable remoting on the machines you wish to call This requires admin privileges, but it's pretty simple unless you need to modify which ports are available, etc. But to get it going the easiest…
Read More