Loading the SQLPS module gives you quick access to the sql cmdlets, sql provider and the SMO assemblies. It also, infuriatingly, moves your location into the sql provider. I (really) * (lots ) hate things that assume what I want to do. You can use PowerShell… Read the full text.
