Microsoft® SQL Server® 2008 Administration with Windows PowerShell™

Introduction

Welcome to SQL Server 2008 Administration with Windows PowerShell. This book is a nuts-and-bolts guide to creating Windows PowerShell scripts that can be used to administer every aspect of the SQL Server 2008 Database Engine. Using a very hands-on approach, this book guides you through the basics of Windows PowerShell, the available Windows PowerShell components that have been integrated into SQL Server 2008, and the actual administration tasks. By providing clear, well-structured examples, SQL Server 2008 Administration with Windows PowerShell shows you how to construct effective and practical solutions that can improve SQL Server administration and monitoring at your company.

SQL Server 2008 delivers a dynamic, smart, and productive data platform for all your data-related needs. SQL Server 2008 offers secure, reliable, and consistent performance. It is also very scalable and flexible, handling any form of data. It is well known in the technology world that SQL Server 2008 is not only a RDBMS, but also has built-in features such as Integration Services for ETL, Analysis Services for Business Intelligence, Reporting Services for report management, and more. This is why Microsoft SQL Server is a cut above all other database products.

Windows PowerShell 2.0 is the new extensible command-line interface shell and scripting language that provides an environment for interactive scripting and non-interactive scripted administration of local and remote computers. Because Windows ...