update-help set-executionpolicy remotesigned $PSversiontable get-module import-module SQLPS psdrive import-module -Name SQLServer -Scope CurrentUser -AllowClobber
Error screenshots and resolution. Issue from SSMS 2017 – Click here to download SSMS 2017 Get Powershell Gallery from this link. Click here.
In order to get this to work in Windows 10 , l ran the command below. Install-module -Name SqlServer -Scope CurrentUser – Force -AllowClobber Useful Links: Powershell Gallery Download SSMS -SQL Server Management Studio
Two very useful commands l use to create a Virtual machines VHDX virtual disk, and resize an existing VHDX virtual hard drive. These were used on a Windows 2012 R2 Server running Microsoft Hyper-v Import-Module Hyper-V New-VHD –Path C:\ClusterStorage\Volume2\HyperV\MyServer\MyServer1_Drive_C.vhdx –Fixed 207GB resize-vhd –Path C:\ClusterStorage\Volume2\HyperV\MyServer\MyServer1_Drive_D.vhdx –sizebytes 507GB Click here for much more Hyper-V powershell commands […]
In this example, l will attempt to get and stop a windows service for say, SQLdefragmanagementservice. First open a windows powershell console, using the run as administrator below. Use the get-process to get the process id. Use the stop-process to kill the windows process/service. Then run the code shown in the screenshot below, modify as […]
Below powershell command will query one or more servers for a specific hotfix as in the example. cls get-hotfix -id KB2883201 -computername server1, server2