Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

Quantity:

More Buying Choices

33 used & new from $0.40

Have one to sell? Sell yours here

Tell the Publisher! I�d like to read this book on Kindle Don�t have a Kindle? Get yours here.

Real-World SQL-DMO for SQL Server (Paperback)

by Mark Allison (Author), Allan Mitchell (Author)
Key Phrases: job outcome, configure publishing, next run date, Enterprise Manager, Cancel Help Figure, Private Sub (more...)

4.5 out of 5 stars See all reviews (4 customer reviews)

List Price:	$49.99
Price:	$49.99 & this item ships for FREE with Super Saver Shipping. Details
	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.

Only 1 left in stock--order soon (more on the way).

Want it delivered Monday, July 20? Choose One-Day Shipping at checkout. Details

16 new from $0.40 17 used from $0.42

Frequently Bought Together

Customers Who Bought This Item Also Bought

Inside Microsoft SQL Server(TM) 2005: The Storage Engine (Solid Quality Learning)

by Kalen Delaney

4.4 out of 5 stars (17) $31.49

Microsoft� SQL Server(TM) 2000 DTS Step by Step (Step By Step (Microsoft))

by Carl Rabeler

3.8 out of 5 stars (8)

MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft� SQL Server 2005 Database Administrator Core Requirements (Pro Certification)

by Solid Quality Learning

4.3 out of 5 stars (12) $88.19

› Explore similar items

Editorial Reviews

Product Description
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 DBAs routinely manage more than 50 SQL Servers, ensuring that the techniques can be implemented on environments of almost any scale.Whether you're a developer or a DBA, this book will take you to the level in SQL Server administration.

About the Author
Mark Allison is a freelance database consultant working for various blue-chip organizations in London. Mark likes to work both as a development DBA/database architect and as a production DBA 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 MVP by Microsoft in 2002.

Allan Mitchell is currently working as a lead data architect for a multinational media company in the United Kingdom. He provides developer and user support over 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 MVP 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.

Product Details

Paperback: 397 pages
Publisher: Apress (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.com Sales Rank: #1,267,783 in Books (See Bestsellers in Books)

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

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.

Help others find this product — tag it for Amazon search

No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

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

Customer Reviews

4 Reviews

5 star:		(3)
4 star:		(0)
3 star:		(1)
2 star:		(0)
1 star:		(0)

Average Customer Review

4.5 out of 5 stars (4 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

5.0 out of 5 stars This is a good book, November 9, 2002

By	Hilary Cotter (Englishtown, NJ, USA) - See all my reviews (REAL NAME)

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

2 of 2 people found the following review helpful:

5.0 out of 5 stars this is a great book, January 12, 2004

By A Customer

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. I am a vb programmer who have been working as a dba for 2 years now. This book more than any other book has helped me cross the threshold from being a programmer to being a dba.

Not only does it help you write code, but it helps you to understand SQL Server in general. It also has helped me with my day to day SQL Server administrative tasks.

One other thing I must mention - I have tried many of the code samples and they work!!! Having code samples work in books you buy is such a rarity today.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

1 of 1 people found the following review helpful:

5.0 out of 5 stars Very useful guide for SQL-DMO., April 29, 2004

By	fcatamazondotcom (LAUDERHILL, FL United States) - See all my reviews

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.