Using the SQL Server PowerShell

Windows PowerShell is increasingly being used in enterprises, and SQL Server 2008 includes extensions to help you take advantage of this powerful shell environment. By default, when you install the Database Engine, SQL Server Setup installs Windows PowerShell and then configures extensions for SQL Server 2008. However, if you’ve already installed the appropriate version of Windows PowerShell, SQL Server Setup installs only the necessary extensions for SQL Server 2008.

Running and Using Cmdlets

Windows PowerShell introduces the concept of a cmdlet (pronounced commandlet). A cmdlet is the smallest unit of functionality in the Windows PowerShell. You can think of a cmdlet as a built-in command. Rather than being highly ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.