#poweshell

I found out that I got two different SQL Servers installed on my developement machine. 

I decided to remove one SQL Server, because one is good enough :).

First i backed up the SP Databases and restore them to the target server I wan't to reconnect the SharePoint instance to the new SQL Server. 

Before I starteing the Configuration Wizard, I disabled the existing Database instance.

  After starting the configuration wizard I got the following error:

That's right, because I "removed" the previous database. I decided to remove the connection by PowerShell:

And create a new one on the new SQL Server

And then I restart the SharePoint config wizard and it finished successfull. 

So far these are the best powershell tutorials I have found online and they're FREE!

They can all be found here http://www.powershellpro.com and I have listed the tutorials in order below to make it easier to follow.

PowerShell Tutorials

PowerShell Console

PowerShell Cmdlet

PowerShell Aliases

PowerShell Parameters, Objects, and Formatting

PowerShell Providers

PowerShell Scripting

Variables, Arrays, and Hash Tables

Conditional Logic

Conditional Logic Using Loops

PowerShell Functions and Filters - The basics

PowerShell Scripting with WMI (Properties)

PowerShell Scripting with WMI Part 2 (Methods)

PowerShell Scripting with WMI Part 3 (Reports)

Managing Active Directory with Windows PowerShell

Here is a really good introduction to Powershell V3 ... it manages to be entertaining and interesting all at the same time.