In previous versions of SSMS, right clicking on any item in Object Explorer and Start Powershell would take you to the location in SQLSERVER: in a Powershell session. This isn't working in 17 or at my installation. .
The complete message is:
No SQL Server cmdlets found on this computer.
Get the 'SqlServer' module at https>//powershellgallery.com/packages/SqlServer
Start Powershell without the SQL Server cmdlets?
The SqlServer module is loaded correctly but it seems SSMS 17 can't see it. I know that the Sqlserver module has been segregated from SSMS and is a separate install. The Web page in Powershell Gallery indicates that SSMS 17 should be able to access the module.
Get-Module sqlserver -listavailable returns:
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.