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

Allan Mitchell (Author), Mark Allison (Author), Gert Drapers (Foreword), Sharon Dooley (Foreword)

Book Description

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

SQL-DMO is a feature rich library that developers can manipulate to get into those hard-to-reach corners that simply are inaccessible using Microsoft SQL Server's standard GUI tools such as Enterprise Manager. The SQL-DMO library allows DBAs and SQL Server application developers to manage replication and security scenarios, for example, with the kind of fine-tuning they just don't get with GUI tools. Allan Mitchell and Mark Allison explain how to do this in a straightforward, concise manner that simply explains the points necessary to help DBAs and SQL programmers advance to the next level of application development. ¿Real-World SQL-DMO for SQL Server¿ shows developers how to administer Microsoft SQL Server using the SQL-DMO object library. This book is packed with code and explanations on how to use the library to its full potential, and Allan Mitchell and Mark Allison offer advice about when--and even when not--to use the SQL-DMO application programming interface (API). With SQL-DMO, you can take a piece of Enterprise Manager and build an application around it. For example, in Chapter 2, the authors build an application to back up and restore a database. Also included is a freeware SQL utility, QALite. ¿Real-World SQL-DMO for SQL Server¿ will take developers and DBAs alike to another level in administering their SQL Server environments. The toolset that's provided with SQL Server becomes cumbersome when dealing with more than 10 servers and next to impossible when dealing with more than 30 servers. This book uses code tried and tested by the authors at sites where DBAs routinely manage more than 50 SQL Servers. Allan Mitchell and Mark Allison are longtime DBAs and cofounders of the successful UK-based consultancy Allison Mitchell (www.allisonmitchell.com). They are regular contributors at SQL Server user group meetings and were both recently honored as Microsoft SQL Server MVPs.

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,566,677 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

7 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)   

This review is from: Real-World SQL-DMO for SQL Server (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.

5 of 8 people found the following review helpful:

3.0 out of 5 stars Generous at 3 stars, February 10, 2003

By A Customer

Amazon Verified Purchase

This review is from: Real-World SQL-DMO for SQL Server (Paperback)

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.

1 of 2 people found the following review helpful:

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

By 

fcatamazondotcom - See all my reviews

Amazon Verified Purchase

This review is from: Real-World SQL-DMO for SQL Server (Paperback)

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.