Microsoft SQL Server 2008 Administration with Windows PowerShell

Overview

Secure, reliable, and scalable, SQL Server 2008 delivers a dynamic, smart, and productive data platform for all your data-related needs and offers many new features that will change how you administer a database server. Among these new features is the ability to use Windows PowerShell 2.0 scripts to automate and manage various aspects of the Windows environment.

Written by well-known and highly respected SQL Server experts, this nuts-and-bolts guide brings together the best of both worlds—database and system administration—to help you manage, automate, and control your environment. You'll discover how to construct effective and practical solutions that can improve SQL Server administration and monitoring while saving you countless hours of manual effort and ensuring more consistent results.

Packed with clear, well-constructed examples throughout, this tutorial-based resource covers the fundamentals of Windows PowerShell so you can get started writing scripts in Windows PowerShell to perform SQL Server 2008 administration tasks immediately.

What you will learn from this book

• How Windows Management Instrumentation Providers for SQL Server enable you to manage SQL Server services and network connectivity
• How to manage SQL Server objects, including the new policy objects using the new SQL Server 2008 support for Windows PowerShell
• Ways to use SQL Server Management Objects to create database and database objects, and backup and restore databases
• Techniques for building an SQL Server inventory over an existing or new environment
• Tips for installing, monitoring, collecting performance data, database scripting, and more, using Windows PowerShell
• Various programming features such as inputs, outputs, debugging, functions, and more.

Who this book is for

This book is for SQL Server database administrators, developers, or system administrators who are looking to manage SQL Server 2008 using Windows PowerShell 2.0. No previous Windows PowerShell experience is assumed.

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

Read More