A Guide to SQL Server 2000 Transactional and Snapshot Replication [Paperback]

Hilary Cotter (Author)

Book Description

Publication Date: November 8, 2004

Having more power and features than any other enterprise RDBMS, Microsoft® SQL Server® Replication has been lacking a clear, consice guide to installing, configuring, and troubleshooting for its users. Finally there is a complete and authoritative reference book that addresses these issues, guiding the reader to use SQL Server replication to its full potential. In more than one thousand pages, Microsoft SQL Server MVP Hilary Cotter shares his extensive knowledge and expertise in SQL Server replication using methods that will be useful to the SQL Server novice as well as the experts.

In A Guide to SQL Server 2000 Transactional and Snapshot Replication, this highly experienced industry expert covers all you need to know to deploy replication in both Microsoft SQL Server only and heterogeneous environments. This text will help the reader master all aspects of SQL Server Transactional and Snapshot Replication through coverage of the following topics:

Installing Replication
A Step by Step Guide to the Wizards
Creating Transactional and Snapshot Publications
Creating Subscribers
Deploying Replication using Stored Procedures
Deploying Replication using SQL-DMO
Deploying Replication using the Replication ActiveX Controls
Replication Internals
Replication Troubleshooting

Editorial Reviews

About the Author

About the Author Involved in IT for more than 20 years as a web and database consultant in the tri-state area of NY/NJ/CT, Hilary Cotter was first recognized by Microsoft in 2001 with the Microsoft SQL Server MVP award. Hilary received his Bachelor of Applied Science degree in Mechanical Engineering from the University of Toronto, and subsequently studied both economics at the University of Calgary and Computer Science at UC Berkeley. He and his beautiful wife Miriam have five children ranging in age from 13 months to six years. Hilary Cotter has A companion volume to this text on merge replication is in the works for 2005.

Hilary has worked for Microsoft, Merrill Lynch, UBS-Paine Webber, MetLife, VoiceStream, Tiffany & Co., Pacific Bell, Cahners, Novartis, Petro-Canada, Associated Press, and Johnson and Johnson.

Product Details

• Paperback: 1016 pages
• Publisher: Not While the Surf's Up Press (November 8, 2004)
• ISBN-10: 0974973602
• ISBN-13: 978-0974973609
• Product Dimensions: 10 x 7 x 2.1 inches
• Shipping Weight: 3.9 pounds
• Average Customer Review: 4.7 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #1,568,710 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars The most comprehensive title on replication... period., February 1, 2005

By 

ABert "ABert" (Rhode Island, USA) - See all my reviews

This review is from: A Guide to SQL Server 2000 Transactional and Snapshot Replication (Paperback)

This is a great book, jam-packed with information that's either tough to find, or doesn't exist, in Microsoft's documentation. I liked that the author delved through the basics, and then showed the pros and cons of each approach (SPs, DMO, ActiveX). He also documented Microsoft's replication system procedures much better than they ever could, and explained some of the caveats that they conveniently leave out.

Probably not a book you would read straight through in a single evening, but if you are involved with replication, this is the one book I think you need to have by your side.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Filling An Important Gap In DBA References, August 10, 2005

By 

Michael Garstin (Mississauga, Ontario) - See all my reviews
(REAL NAME)   

This review is from: A Guide to SQL Server 2000 Transactional and Snapshot Replication (Paperback)

A book dedicated to all aspects of SQL Server replication is long overdue. I was excited to learn that one finally existed and asked several Microsoft Support Engineers who work with replication daily if they knew about it.

I received one particularly enthusiastic response and almost immediately afterward ordered Cotter's book. I have not been disappointed.

Many DBA reference books are designed to let you read just a few relevant paragraphs. That's possible here too, but you will also want to read entire chapters for the most solid foundation on replication.

I eagerly await the next book on merge replication.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Want to do replication? This is your book., February 9, 2005

By 

Adam Machanic "Data Dude" (Melrose, MA United States) - See all my reviews
(REAL NAME)   

This review is from: A Guide to SQL Server 2000 Transactional and Snapshot Replication (Paperback)

This book is the only choice for a reference on replication -- and not just because it's literally the only book available, but also because Cotter has jammed it full of information. This book covers every aspect of transactional and snapshot replication, from basics all the way through to deep internals. Cotter leaves few, if any, issues uncovered.

For replication beginners -- like me -- this book is certainly not an easy read. Replication has a steep learning curve, with lots of new terminology to learn. And it's a huge topic -- this book can only be fairly described as a tome. However, Cotter's casual writing style helps the reader get comfortable with replication quickly and easily.

I would recommend this book to anyone who wants to successfully work with replication.