Microsoft SQL Server 2008 Administration with Windows PowerShell

The definitive guide to automating SQL Server admnistration with Powershell scripts
If you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server.