Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Buy Used
$6.72
+ $3.99 shipping
Used: Good | Details
Condition: Used: Good
Comment: Good condition. NOT EX-LIB. Pages have writing and/or highlighting. Cover has shelfwear. Spine strong, binding has wear. May have dogears. We ship daily. ENJOY!!
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

A Guide to SQL Server 2000 Transactional and Snapshot Replication Paperback – November 8, 2004

4.7 out of 5 stars 12 customer reviews

See all formats and editions Hide other formats and editions
Price
New from Used from
Paperback, November 8, 2004
"Please retry"
$68.42 $6.72

Excel2016ForDummiesVideo
Excel 2016 For Dummies Video Training
Discover what Excel can do for you with self-paced video lessons from For Dummies. Learn more.
click to open popover

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.

NO_CONTENT_IN_FEATURE

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 1016 pages
  • Publisher: Not While the Surf's Up Press; First Edition edition (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: #3,213,529 in Books (See Top 100 in Books)

Important Information

Ingredients
Example Ingredients

Directions
Example Directions

Customer Reviews

Top Customer Reviews

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.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
I have been waiting for a SQL Server replication book for the last few years and was excited to get hold of one of the first copies. Replication has been crying out for a comprehensive manual and finally we now have one. Firstly, it's a big tome - almost 1000 pages. If you've used replication before this'll be no surprise, as it is a deceptively 'wide' subject that really requires this size of book to do it justice. There are plenty of screenshots throughout the book to help guide newcomers and the first 5 chapters should take a complete beginner and make him more than proficient in planning and implementing snapshot and transactional replication. Some of this info is also in the microsoft help guide (Books On Line, BOL) but much is not - especially replication to other database systems, and many generally useful little tips. Later chapters concentrate on programming, replication internals and troubleshooting - valuable topics which IMHO need to be understood if you want to successfully support replication, and again topics which neither BOL nor on the net are really adequately covered. So, if you're thinking of getting involved with replication or even if you've been using it for some time - either way I'd definitely recommend getting this book.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
I'm new to SQL Server replication and this book is exactly what I needed. Mr. Cotter's book provides insights, tips and experiences that have put me far ahead of the learning curve. He distills his diverse knowledge on the subject into a form that is very helpful for the novice, like myself, and I suspect it is also helpful for the person that is moderately experienced with replication and the replication pro. Don't be intimidated by the size of the book. It's loaded with good information that isn't easily found by floating around the Internet. The personal touches in this book are nice too. I highly recommend this book.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
The first and only a fully comprehensive book on Transactional replication, filling a gap that has existed for over five years. I found it easy to read, and I like that it covers both the surface phenomena like wizards, and internals such as tables and stored procedures. By taking time with both, the book adds a nice perspective to a very complex topic. It also avoids the scattershot approach of online help.

Just a couple of days after getting the book, I jumped ahead to the internals of the distribution database and based on Hilary's info, write a query to monitor the progress of transactions. Very nice!
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews