About

Resources
TechNet Windows PowerShell
TechNet Scripting Center: Scripting with Windows PowerShell
TechNet Wiki: Windows PowerShell Survival Guide

With the release of SQL Server 2008, SQL Server PowerShell was introduced. It is a powerful tool that can be used to automate many repeative task. You will also see some folks that use it for deployment and to standardize tasks/objects across many servers.

Powershell is also able to use .NET frameworks, which is especially handy for SQL Server when using the SQL Management Objects API. Some starter links on SMO are here:

Basic interface
More in-depth look at SMO objects
MSDN guide to overall SMO Object Model

SQL Server PowerShell offers some information regarding use of PowerShell within the context of SQL Server.

Posting Questions
As always you can read through the FAQ to get general ideas of how to ask your question. Any question you do post regarding PowerShell on this site should involve SQL Server in some manner. This can include working with SQLPS or SQL Server Management Objects (SMO).

history | show excerpt | excerpt history