Buy Used
$2.08
+ $3.99 shipping
Used: Very Good | Details
Condition: Used: Very Good
Comment: Appearance of only slight previous use. Cover and binding show a little wear. All pages are undamaged with potentially only a few, small markings. Help save a tree. Buy all your used books from Green Earth Books. Read. Recycle and Reuse.
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


See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback, November 8, 2004
"Please retry"
$79.56 $2.08
Best%20Books%20of%202014
NO_CONTENT_IN_FEATURE

Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

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: #2,477,009 in Books (See Top 100 in Books)

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.

Customer Reviews

4.7 out of 5 stars
5 star
10
4 star
0
3 star
2
2 star
0
1 star
0
See all 12 customer reviews
By taking time with both, the book adds a nice perspective to a very complex topic.
R. Talmage
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.
Mr. Paul Ibison
This book covers every aspect of transactional and snapshot replication, from basics all the way through to deep internals.
Adam Machanic

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By ABert on February 1, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Mr. Paul Ibison on February 4, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Adam Machanic on February 9, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Michael Garstin on August 10, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Kretch on November 21, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By R. Talmage on February 11, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again