Programming Books C Java PHP Python Learn more Browse Programming Books
and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $59.99
  • Save: $18.51 (31%)
In Stock.
Ships from and sold by
Gift-wrap available.
FREE Shipping on orders over $35.
Used: Very Good | Details
Sold by jubileebooks
Condition: Used: Very Good
Comment: Text unmarked.
Access codes and supplements are not guaranteed with used items.
Trade in your item
Get a $2.00
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft SQL Server 2008 Administration with Windows PowerShell Paperback – May 22, 2009

ISBN-13: 978-0470477281 ISBN-10: 0470477288 Edition: 1st

Buy New
Price: $41.48
25 New from $31.56 25 Used from $18.13
Amazon Price New from Used from
"Please retry"
"Please retry"
$31.56 $18.13

Frequently Bought Together

Microsoft SQL Server 2008 Administration with Windows PowerShell + Microsoft SQL Server 2008 R2 Unleashed
Price for both: $83.37

Buy the selected items together
  • Microsoft SQL Server 2008 R2 Unleashed $41.89


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 580 pages
  • Publisher: Wrox; 1 edition (May 22, 2009)
  • Language: English
  • ISBN-10: 0470477288
  • ISBN-13: 978-0470477281
  • Product Dimensions: 9.1 x 7.5 x 1.2 inches
  • Shipping Weight: 1.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Best Sellers Rank: #676,190 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

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.

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 11 customer reviews
The writing style is lucid and the book is very easy to follow.
Anuj K.
A number of well formed complex scripts are introduced here to give the reader some excellent ideas of how to use Powershell to manage the database configuration.
Robin T. Wernick
I really highly recommend anybody who wants to admin SQL at ease get this book.
C. Chang

Most Helpful Customer Reviews

11 of 12 people found the following review helpful By Julie SQL on June 21, 2009
Format: Paperback
This book pretty much covers everything I needed. I fully recommend it to anyone needing an update on their SQL Server administration and development skills.
Very useful information about new features in SQL Server 2008 and how to manage it using Windows PowerShell. The chapter on Monitoring SQL Server (Chapter 18) is pure gold and extremely useful. It covers monitoring blockings, deadlocks, and windows event logs which are essential to ensure the stability of SQL Server environment, and they get right to the point. Another beauty is Chapter 14, covers SQL Server standards, development standards, Database Design standards and best practices, Data protection standards, production standards, and Windows PowerShell coding standards, and those are milestones for DBAs.
This is an excellent reference book, and I strongly recommend it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Salomon Young on July 30, 2010
Format: Paperback
I recommend this book to all database administrators who still have not jumped in and executed their first PowerShell command. I know of several DBAs who for one reason or another, keep postponing their exposure to the next generation command line shell. This volume makes a good first PowerShell book for DBAs. It covers the basics of the language with enough examples to get you going and good coverage of what is possible when combined with MS SQL 2008.

The first ten chapters go over specifics of the language, programming syntax, and how to interact with different areas of the operating system. The following eleven chapters demonstrate with code samples, how integrated are MS SQL 2008 and PowerShell. I have found that many of the examples in this book also apply to MS SQL 2005. My favorite chapter is 15 "Building SQL Server Inventory" because the authors provide a working solution to a common problems DBA have when managing many database servers.

To those DBAs who still have not jumped in, do yourself a favor and read this book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 13 people found the following review helpful By yodalego on April 15, 2010
Format: Paperback Verified Purchase
Great content, poor marketing and very poor title!

Very good outline of how powershell works, may I suggest that WROX remove the 50 pages of SQL content and re-label the book as a great beginning tutorial to learning Powershell.
This book is very weak on the how to setup a competent SQL connection to and use it to manipulate SQL server like a DBA would like to do.

This is not a problem with the authorship, they are just doing what they have access to as far as tools from Microsoft. Currently Microsoft only provides a Mini-shell connection, and a modified SQLCMD connection that negates any benefits that powershell brings to working with SQL Server.

This book uses the tools that are available to them from Microsoft which is limited to a mini-shell and SQLCMD.exe type connection to SQL server. These types of connections work well in straight scripting but are very cumbersome, verbose and chatty, when it comes down to writing powershell routines. As such there is not much the authors can do to help the DBA automate SQL task functions in this environment. Given this limited connectivity there is not much you can't accomplish by directly working in SQLCMD.exe, which also limits the desirability of this book to SQL Server professionals.

What most DBA's are looking for is a powershell IDE environment that has direct access to all SMO assembles, where there are commands to call manipulate all the fine details of SQL Server are found.
Currently this book doesn't cover access to all the SMO assemblies because the Microsoft branded tools to do so don't exist. There are free third party snapins that could have been written about to fix this problem but they are not mentioned in this book.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 8 people found the following review helpful By Robin T. Wernick on March 11, 2011
Format: Paperback Verified Purchase
Powershell is a recent development in the Microsoft operating system world that has great potential for control and automation of many operating system processes. It supersedes the older batch file methods and previous scripting languages. However, it is a notable departure from the previous languages and has a much higher level of complexity. It takes a careful approach to introduce this complex subject successfully and this book falls short in a few ways. Still, I say with a few reservations that this book is a good introduction to the Powershell world and is virtually the only one that deals thoroughly with Powershell management of SQL Server databases. As with many other complex subjects, getting the complete viewpoint from a number of books is much more revealing and productive in mastering the material. I recommend Manning's "Powershell in Action" to complete your training in this material.

The first four chapters of the book are almost a classic introduction to Powershell itself. The scripts are shown in the Powershell window which gives the reader the best understanding of how the overall commands and programs should look. Several other books provide only code fragments and show developments in disconnected text which leaves the reader confused as to how the final program should be formed.

Chapters five through ten introduce Powershell control over the file system, Registry and the operating system WMI reporting on processes and configuration management. Although, this is wonderful support material, it lacks a topside explanation of why and how this control should be used.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

What Other Items Do Customers Buy After Viewing This Item?