For SQLPS, you'll need to install the SQL Server 2008 Client tools at the very least. Beyond just the command line, there's also a scripting tool, called powershell_ise.exe (see Fig. 1).

If you are running PowerShell V5, you can use Install-Module to download and install the module from the PowerShell Gallery. Otherwise you can download the module from the ... That was very cool to ...

This is when you need to focus on automation tools like Windows PowerShell. To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages.

Before you perform any Azure task with PowerShell, you must install the AzureRm PowerShell module (Install-Module -Name AzureRm) and authenticate to Azure properly using the Add-AzureRmAccount ...

PowerShell vs. SQL Server Management Studio When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 ...