How do I run powershell scripts on a remote server?

SETUP/INSTALLATION 1 – install powershell 2.0/windows management framework on local machine and remote servers that you want to manage. http://support.microsoft.com/kb/968929 – running scripts on a remote machine only works in powershell 2.0 — both...

What is powershell?

INTRO READING – What is PowerShell? http://en.wikipedia.org/wiki/Windows_PowerShell – Windows Management Framework (Windows PowerShell 2.0, WinRM 2.0, and BITS 4.0) http://support.microsoft.com/kb/968929

How to Change Your SQL 2008 Database Instance Name

So with a little hunting and SQL queries I found out that SQL Server doesn’t use the network name, it only excepts that as an alias. My SQL Server instance was still named “old_name”. I found that out by running these two queries: 1 sp_helpserver 2 select @@servername...