Pro SQL Server 2008 Replication (Expert's Voice in SQL Server) [Paperback]

Sujoy Paul (Author)

Book Description

ISBN-10: 143021807X | ISBN-13: 978-1430218074 | Publication Date: June 17, 2009 | Edition: 1

Pro SQL Server 2008 Replication is the only book on the market to provide comprehensive guidance to database administrators on how to implement a distributed database environment under SQL Server. The book covers all common replication paradigms, and is essential reading for anyone involved in replicating databases.

Editorial Reviews

About the Author

Sujoy Paul is a results-oriented database and software professional with extensive experience in different relational database management systems like MS SQL Server 2000, Sybase ASA, and Sybase ASE; data modeling; case-based tools like PowerDesigner; and coding and testing in demanding hi-tech environments. Sujoy’s background includes expertise in database replication, with special interest in two-way replication, backup and recovery, performance and tuning, and troubleshooting. Sujoy has a demonstrated ability to provide training for replication and Microsoft certifications on design and administration of SQL Server 2000. Sujoy is a Microsoft Certified Professional (installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition).

Product Details

• Paperback: 936 pages
• Publisher: Apress; 1 edition (June 17, 2009)
• Language: English
• ISBN-10: 143021807X
• ISBN-13: 978-1430218074
• Product Dimensions: 9.1 x 7 x 2 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 2.7 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #613,849 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

1.0 out of 5 stars Not much help if you are in a production environment..., December 29, 2009

By 

Michael Hestness (Bellevue, WA USA) - See all my reviews
(REAL NAME)   

This review is from: Pro SQL Server 2008 Replication (Expert's Voice in SQL Server) (Paperback)

This book does a good job of explaining how different types of replication work but if you are planning to setup replication properly which is amongst several machines this book will be a great door stopper as it only explains how to setup replication as a distributor, publisher and subscriber on the SAME machine. Who does this? Why would you do that? What good is a replicated copy of a database on the same server if it fails? Then both your production database and your replicated database are toast.

This book would have been useful and worth the nearly $70 if it had explained the very complicated permissions that are required on a domain and server to get replication working. I have been ripping my hair out trying to get the right voodoo mix of permissions to get it working and even after reading this book can't get it to work.

Save your money, the vast majority of this information is already available in the Sql Books Online.

1 of 1 people found the following review helpful:

2.0 out of 5 stars confusing figures, October 15, 2009

By 

F. van der Geer (Rotterdam, Netherlands) - See all my reviews
(REAL NAME)   

This review is from: Pro SQL Server 2008 Replication (Expert's Voice in SQL Server) (Paperback)

I am only at chapter 2, but this book is starting to anoy me.

I trully believe that the author masters the subject, but explaining it is another job. The conceptual explanation of the Publisher/Subscriber metaphor is intertwingled with SQL Server implementation details. There is no clear separation between concepts and implementation.

But it gets worse. My impression is that the author is not a native English speaker. His message is not formulated precisely; It lacks consistent use of the words "to" and "from" and "request" and "response". Object and subject are not crystal clear. The figures that are supposed to illustrate things are not effective and not coherent with the text. Figure 2-3, for example, tries to illustrate how publishing with a pull subscription works. The figure shows the artifacts "Publisher", "Distributor" and "Subscriber". Numbered arrows should depict the control flow, which is described in text. The arrow labeled "Publisher enables the subscriptions" is inside the artefact "Subscriber". Even worse, the arrow starts at the subscription database, not at the publisher at all.

I think that readers who are new to the subject get lost by this kind of inconsistencies.
That said, there is no other book that devotes so many pages to the subject.
But don't take every word literally.

3.0 out of 5 stars Stepping stone into SQL Replication, November 14, 2011

By 

SQL Learner - See all my reviews

This review is from: Pro SQL Server 2008 Replication (Expert's Voice in SQL Server) (Paperback)

I am new to SQL Replication & this book helped me understand the replication basics, and understand what options I have and which would be better for a given scenario. Each type of replication is covered to a great extent, followed by backup and recovery. I am still in the initial chapters, the snapshots and the step-by-step explanation helped me understand it well without actually implementing it. However I did not complete the entire book and am not sure what kind of issues would be encountered in real time environment. I still would recommend this book as a stepping stone into the world of SQL Replication.