Windows PowerShell is a powerful scripting tool that can help System Administrators to manage the servers in an automated way using scripts. A .NET assembly contains Windows PowerShell providers and CmdLets that extends the functionality of the shell. Similarly, PowerShell for SQL Server is available from SQL Server 2008 version onwards. During the SQL Server installation process, PowerShell and PowerShell snap-ins are installed to expose the SQL Server functionality from PowerShell.
In this recipe, we will go through the steps to implement and run PowerShell for SQL Server in an existing data platform.
In order to implement PowerShell for SQL Server, the operating system must have the PowerShell feature installed. In Windows Server 2008 onwards, PowerShell is a separate install, which requires you to download and install an external package.
To ensure PowerShell is installed on the operating system, open Server Manager...