SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Using SQL Server PowerShell Extensions

In order to take advantage of PowerShell for SQL Server administration, you'll need to download the Microsoft Windows PowerShell Extensions for SQL Server. The extensions add a PowerShell provider that allows navigation through a SQL Server instance much like browsing through a directory structure. Additionally, it will install several cmdlets (command lets—something like applets in the Control Panel) that allow for tasks such as converting data from one structure to another and invoking commands against the SQL Server.

Once you've downloaded the extensions (which you'll find best by visiting Microsoft.com and searching for Microsoft SQL Server 2008 Feature Pack), the installation process is simple. First, ...