O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing and running PowerShell for SQL Server features

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.

Getting ready

In order to implement PowerShell for SQL Server, the operating system must ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required