Quantity:


	Amazon Prime Free Trial required. Sign up when you check out. Learn More

More Buying Choices

Have one to sell? Sell yours here

Share your own customer images

Search inside this book

Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Real-World SQL-DMO for SQL Server [Paperback]

Allan Mitchell (Author), Mark Allison (Author)

(4 customer reviews) |

List Price:	$49.99
Price:	$36.49 & this item ships for FREE with Super Saver Shipping. Details
Deal Price:
You Save:	$13.50 (27%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Friday, May 18? Choose One-Day Shipping at checkout. Details

Book Description

Publication Date: October 11, 2002 | Series: Expert's Voice

Real-World SQL-DMO for SQL Server delves into the details of administering Microsoft SQL Server using the SQL-DMO object library. Authors Allan Mitchell and Mark Allison have packed the book with explanations and working code that will help you use the library to its full potential. Additionally, Mitchell and Allison offer advice about when (and when not) to use the SQL-DMO application programming interface (API).

The code in this book has been tried and tested at sites where database administrators routinely manage more than 50 SQL Servers, ensuring that the techniques can be implemented on environments of almost any scale.

Whether youre a developer or a database administrator, this book will take you to the next level in SQL Server administration.

#outer_postBodyPS { display: none; } #psGradient { display: none; } #psPlaceHolder { display: none; } #psExpand { display: none; }

Whether youre a developer or a database administrator, this book will take you to the next level in SQL Server administration.

Editorial Reviews

About the Author

Allan Mitchell works as a lead data architect for a multinational media company in the United Kingdom. He provides developer and user support for all the company's SQL Servers, and he designs data solutions as well. He is an MCSE and an MCDBA, and in 2002 he was awarded the title of "Most Valuable Professional" by Microsoft. His interests include mountain biking and rugby. You can find Allan on the Microsoft public newsgroups and on the SSWUG list answering questions on a variety of topics. Allan is cofounder of Allison Mitchell Database Consultants Ltd., a successful database-consulting firm based in southeast England.

Mark Allison is a freelance database consultant working for various blue-chip organizations in London. Mark likes to work both as a development database administrator/architect and as a production database administrator to keep his feet on the ground. Mark is also cofounder of Allison Mitchell Database Consultants Ltd., a successful database-consulting firm based in southeast England. Mark is a SQL Server MCP and was awarded the title of "Most Valuable Professional" by Microsoft in 2002.

Product Details

Paperback: 397 pages
Publisher: Apress; 1 edition (October 11, 2002)
Language: English
ISBN-10: 1590590406
ISBN-13: 978-1590590409
Product Dimensions: 9.5 x 7.5 x 1 inches
Shipping Weight: 1.9 pounds (View shipping rates and policies)
Average Customer Review: 4.5 out of 5 stars See all reviews (4 customer reviews)
Amazon Best Sellers Rank: #2,695,369 in Books (See Top 100 in Books)

Would you like to update product info or give feedback on images?

Customer Reviews

5 star

4 star

3 star

2 star

1 star

4 reviews

4.5 out of 5 stars

Write a customer review

Most Helpful Customer Reviews

7 of 8 people found the following review helpful

This is a good book November 9, 2002

By Hilary Cotter

Format:Paperback

I had to do some SQL DMO scripting and could not figure out how to do it using MDSN, so I purchased Wrox's book and found it to be merely a re-write of online docs.

Then I discovered this book and was so overjoyed to find some authors who had actually taken the time to write useful code samples and to go well beyond where MSDN leaves off.

Their code is very well laid out and designed. They have taken the time and care to turn out a quality product.

Comment |

Was this review helpful to you?

Yes

5 of 8 people found the following review helpful

Generous at 3 stars February 10, 2003

By A Customer

Format:Paperback|Amazon Verified Purchase

I'd be kinder with the stars if the title were "Learn Database Administration using SQL-DMO". But I am already clear about that. The only reason I went with 3 was that some of the scripts are indeed useful. But what I was looking for was a good succint overview of SQL-DMO. Rather than focus on the SQL-DMO object model and how best to employ it, the book is a series of tasks DBA's might typically want to accomplish with example code. What I needed was answers to how do you know to use such and such method over some other alternative. Or even a discussion on the pros and cons of techniques employed woud have been more helpful.

Comment |

Was this review helpful to you?

Yes

1 of 2 people found the following review helpful

Very useful guide for SQL-DMO. April 28, 2004

By fcatamazondotcom

Format:Paperback|Amazon Verified Purchase

This book helped me to write SQL-DMO programs for configuring merge replication and performing database backups. It has very good examples of how to use SQL-DMO in Visual Basic and Transact SQL. The examples helped me to write my own SQL-DMO programs in C#, VBScript and InstallShield Developer InstallScript.

Comment |

Was this review helpful to you?

Yes

› See all 4 customer reviews

Write a customer review

Most Recent Customer Reviews

this is a great book

I bought this book to help me with a task I had. not only is it a fun read, but it is packed with helpful scripts and information. Read more

Published on January 12, 2004

Front Cover | Table of Contents | First Pages | Index | Surprise Me!

Inside This Book (learn more)

Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
job outcome, configure publishing, next run date, create publication wizard, server group, dmo server, min server memory, new database role, pager days, token automatically, scripting options, affinity mask, transaction log backup, indexed view, merge replication, database roles, log shipping, registered servers, entire server, log backups, server login, backup device, server roles

Key Phrases - Capitalized Phrases (CAPs): (learn more)
Enterprise Manager, Cancel Help Figure, Private Sub, Server Books Online, Source of Failure, Getting Started, End If Next, Visual Basic, Server Agent, Select Case, Cancel Apply Help Figure, Back Next, Name Next, Query Analyzer, Private Function, Add User, Database Settings, Server Settings, Program Files, Print Description of Failure, End Sub, End Select, Cancel Figure, Nothing Set, Text Case

Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }