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, ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
