|
Microsoft SQL Server 2008 Administration with Windows PowerShell (Wrox Programmer to Programmer) |  | Authors: Ananthakumar Muthusamy, Yan Pan
Publisher: Wrox
Category: Book
List Price: $59.99
Buy New: $6.00
as of 7/30/2010 03:42 CDT details
You Save: $53.99 (90%)
New (39) Used (13) from $5.77
Seller: -hungrybookworm
Rating:  7 reviews
Sales Rank: 24309
Media: Paperback
Edition: 1
Pages: 576
Number Of Items: 1
Shipping Weight (lbs): 1.8
Dimensions (in): 9 x 7.2 x 1.3
ISBN: 0470477288
Dewey Decimal Number: 005.282
EAN: 9780470477281
ASIN: 0470477288
Publication Date: June 9, 2009
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
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. You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort. - The new release of Microsoft SQL Server 2008 now includes Windows PowerShell, allowing administrators of large-scale enterprise databases to automate many tasks
- SQL Server 2008 Administration with Windows PowerShell introduces you to PowerShell, covering its components in detail as well as providing basic instruction in using scripts to administer the database
- The book includes numerous examples of SQL tasks that have been automated and also provides completed scripts that you can put to use immediately
- The Companion Web site includes complete code scripts
If you're a database administrator, the scripts and techniques in SQL Server 2008 Administration with Windows PowerShell will save you hours of effort.
|
| Customer Reviews:
Showing reviews 1-5 of 7
 Good book, poor marketing and title April 15, 2010
yodalego (mpls mn usa)
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.
I think Wrox knew about a market for a book and tried to address that need and clearly missed what the customers who were going to buy the book wanted from it.
This book is printed on newsprint quality paper (the pages are tan not bright white) yet this book still costs $60.00 retail very unprofessional and hard to read unless you're in perfect lighting conditions.
 It helps you become a pro! January 26, 2010
Claire Hsu (NJ, USA)
0 out of 1 found this review helpful
Being a DBA, I am always looking for ways to improve my environments, automate management utilities and monitoring processes. With the help of powershell scripting, I can setup efficient and well-around system architecture for my SQL Server environments. Powershell has better integration with SQL Server, I no longer need to write lengthy batch files, VBScript and T-SQL Code for the missions I am trying to achieve, with simple and straightforward poweshell scripting, I get to complete my tasks faster and effectively.
This book provides step-by-step instructions with clear screenshots, so readers don't get confused with the puzzles between words. Also it provides lots of samples that are ready to be implemented into the system with little customization required to fit into your environments.
I highly recommend this book.
Great refrence book January 13, 2010
C. Chang (NJ, USA)
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.
Whenever I needed something, I just looked it up. I never read the book from the beginning to the end. I just jumped into the section I needed.
The book is well written and the examples are easy to follow. I really highly recommend anybody who wants to admin SQL at ease get this book.
A must have for anyone working with SQL or Servers September 11, 2009
MiguelB (Brooklyn, NY USA)
0 out of 1 found this review helpful
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. Anyone working in the IT field knows that theories are what we use to solve problems, not every solutions works. This book has given me some ideas on how to better monitor, and build servers, and I know that this can be used to help out DBA's when they get stumped. I recommend buying this book and using it as reference at the very least, but if you read it in its entirety you will not regret it.
A great SQL 2008 / windows powershell book August 23, 2009
JeffDBA (London, England)
3 out of 4 found this review helpful
This leads you step by step from your first Powershell script through to how to implement a complete SQL Server Monitoring Solution.
Every aspect is covered whether that be working with event logs, registry access or the real gem of obtaining server metrics and performance monitoring. With clear script examples throughout, available on-line, this book really can save you time and effort.
Showing reviews 1-5 of 7
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
