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

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

Editorial Reviews

Product Description

<p><i>Real-World SQL-DMO for SQL Server</i> 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 <i>not</i>) to use the SQL-DMO application programming interface (API). <p>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.</p>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,327,211 in Books (See Bestsellers in Books)

Customer Reviews

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.

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.

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.