Learn PowerShell Core 6.0

The SQL Provider

The key distinguishing feature of the SqlServer module is the SQL Provider, enabling users to mount a PSDrive and navigate SQL instances as if they were files and folders. This is very useful when discovering an unknown SQL instance's layout, as listing its structure is literally a simple act of running the following:

Get-ChildItem -Recurse

Of special significance about this provider is that if your current path is in one particular database, several commands will use the current path's properties as parameters specifying the target, taking precedence over explicitly bound parameters, unless disabled. This is not consistently implemented across the module; all commands that do this contain a -IgnoreProviderContext parameter. ...