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 worldsdatabase and system administrationto 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 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.
As Database Administrator, I got this book an important tool covering all of my expectations about the needs to stay updated on the Server administration and development of skills... Read morePublished on April 4, 2012 by Luis Charti
This book takes your SQL Server skills to the next level. It explains the scripts very well and the SMO object model. Read morePublished on December 27, 2010 by Bob Jones
Being a DBA, I am always looking for ways to improve my environments, automate management utilities and monitoring processes. Read morePublished on January 25, 2010 by Claire Hsu
I am not a SQL admin. But recently, I have to take care of SQL 2008 severs for a small company. This book helped me dramatically. Read morePublished on January 13, 2010 by C. Chang
I read this book, and I keep it handy because it is a great reference guide. This book not only gives you real world solutions, but it goes through the theories. Read morePublished on September 11, 2009 by Dominican Brooklyn Native
This leads you step by step from your first Powershell script through to how to implement a complete SQL Server Monitoring Solution. Read morePublished on August 23, 2009 by JeffDBA