Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Microsoft SQL Server 2008 Administration with Windows PowerShell
 
 

Microsoft SQL Server 2008 Administration with Windows PowerShell [Kindle Edition]

Ananthakumar Muthusamy , Yan Pan
1.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £39.99
Kindle Price: £37.99 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £2.00 (5%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £37.99  
Paperback £39.99  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more

Product Description

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.

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.

Product details

  • Format: Kindle Edition
  • File Size: 18755 KB
  • Print Length: 580 pages
  • Publisher: Wrox; 1 edition (6 Jan 2011)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B004IK9XNI
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 1.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #580,139 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

5 star
0
4 star
0
3 star
0
2 star
0
1.0 out of 5 stars
1.0 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
1.0 out of 5 stars Very laboured. 26 July 2012
Format:Paperback
From the code fragments, I suspect the authors knew the subject well.
However, that's about as much as I can say to recommend it; Any book that has to lead an administrator through the installation of .Net (showing screen shots of click through and even ones of progress bars and EULA splash screen!) is not a book for administrators.
There's a section on SQL Admin, which is covered far better in other books (and could even be construed as damaging by its lack in certain areas), writing SQL (which any DBA should be able to do at a fair level anyway).
Trying to explain "Start > Run" with screen shots (multiple times) about had me wanting to tear my hair out.
Really, this book would be for you if you wanted to get into SQL Server as a home admin, and wanted to learn a bit of SQL and a bit of Powershell too. I've been flipping through it trying to sift out any useful bits on info from the majority of it which I already know (and I'm only just starting in on Powershell).
Definitely not a resource book to rely on, and definitely not a book to learn powershell with ("Windows PowerShell 2.0 Administrators Pocket Consultant" does that really well if you're after systems work).
It's definitely not a book to learn SQL with, which it tries to do..
Overall, I found it patronising, overly dumbed down (with pages and pages of screenshots of irrelevant things), with very little meat to it. I suspect to be useful, this book could have been written in about 10 pages and been a lot better for it.
Including the Index and cover.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  11 reviews
11 of 12 people found the following review helpful
5.0 out of 5 stars Great book. Just what I needed, !!! 22 Jun 2009
By Julie SQL - Published on Amazon.com
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.
6 of 6 people found the following review helpful
4.0 out of 5 stars Good 1st PowerShell Book for DBAs 30 July 2010
By Salomon Young - Published on Amazon.com
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.
11 of 13 people found the following review helpful
2.0 out of 5 stars Good book, poor marketing and title 15 April 2010
By yodalego - Published on Amazon.com
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.

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.
7 of 8 people found the following review helpful
4.0 out of 5 stars Almost SQL Database management through Powershell 12 Mar 2011
By Robin T. Wernick - Published on Amazon.com
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. The author is very competent in his design of these control scripts but he seems too close to the subject and doesn't explain at all how they fit into the overall remote management philosophy of servers and client computer clusters. Since Powershell was developed with this primarily in mind, it is a puzzling aspect of this introduction. However, I did find a supporting culture at Microsoft that didn't know how to teach its philosophy of design and use well that might explain this oversight. In that culture it is simply expected that a final mastery will happen by osmosis and nothing more should be said about that matter. I believe that attitude is incorrect for books that are meant for the general public. Since the book is probably the only source for the reader to achieve competence, it should be required to have the philosophy of this software tool well explained.

Finally, in chapter eleven, the book introduces the two methods that Powershell can use to affect SQL Server databases. By chapter thirteen the real capabilities of Powershell are displayed in the use of SMO. My favorite chapter in this series is chapter sixteen. I expect that many of the readers are interested in Powershell so that they can build installation scripts that automatically create and configure SQL Server databases. 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.

However, and as before, the real value of this is not explained by the author. So I will fill in for him instead. Many highly rated database authors have stated that databases exist for applications and that application control and access to databases is why tools like Powershell exist. I believe that manual administration of databases is a form of primitive technology. If you go to the CodeProject, you will be able to see how a program can provide the external intelligent management that will allow for Powershell automation. Take the Powershell introduction here and build an intelligent program wrapper around it.

The last few chapters of the book discuss SQL Server monitoring and managing system policies. This is an important area for DBAs, but lacks the sexy pote3ntial of the middle chapters. Here the book winds down into mundane matters that IT gurus need in order to complete the administrative knowledge that allows large groups of computers to work together reliably.

I recommend this book because it lays in the bottom layer of instruction needed to master Powershell in the area of databases. The reader will have to supply the imagination to see that this knowledge can be easily extended to design software programs that can provide automation of database installation and management. The 21st century is already here, let's link our minds as well as our computers and provide intelligent results to increase the productivity and reliability of computer systems.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great refrence book 13 Jan 2010
By C. Chang - Published on Amazon.com
Format:Paperback
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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category