Steve Jones explains how to query a named instance in Powershell:
I was looking at some sample code the other day and it looked like this.
cd sqlserver:\sql\localhost\default\databases
This allows you to browse the list of databases on your local instance. However, this is for a default instance, which I don’t have on this host. How can I get to a named instance? Usually I connect as .\SQL2016, so where does that fit in PowerShell?
Read on for the answer.