SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)

SQLAuthority News - Book Review - Pro SQL Server 2005 Replication (Definitive Guide) proreplication

Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover)
by Sujoy Paul (Author)

Link to Amazon

Quick Review:
This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept and methodology at one place.

Detail Review:
Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility. Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending of subsequent updates.

This books talks about different replication types and methods. This book explains different scenarios where types of replication can be used. Sujoy Paul (SQL Server – MCP) explains the concept with many screenshots and simple examples. This book is not limited to replication types only but it also covers replication between heterogeneous databases and other objects.

Pros :

  • Lots of screen shots
  • Lots of explanation of how different procedures works
  • Good coverage of different kind of replications
  • Step by Step guidance
  • Complete coverage of any methodology
  • Truly useful to novice programmers

Cons:

  • No discussion about potential errors can come across during replication process
  • Some of the screen shots are hard to read (Apress should look into this matter)
  • Some of the chapters are very blurry

Overall, this is great book for any novice developer who is beginning in the world of replication. Though this book covers many screenshots and material directly from Book On Line this is great collection of all the concept at any place. I have personally used this book when I was new DBA and have learned replication basics from this book.

Stars: 4 Stars

Summary: This a comprehensive single source of information will save lots of time as there is no need to go through multiple books to implement and maintain replication solutions.

Reference : Pinal Dave (https://blog.sqlauthority.com)

, , , , ,
Previous Post
SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh
Next Post
SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only

Related Posts

3 Comments. Leave new

  • Hi,

    Need some help regarding SQL server 2005 .

    I have set up replication on SQL server 2005 with tables and Clustered and non clustered indexes being replicated.

    What i want to know here is what are the important parameters to be monitored and how to set up Notification alerts for the monitoring of these parameters or failures .

    Thanks

    Pravin

    Reply
  • Hi Pinal,

    I’m planning to set up a peer-to-peer replication system on SQL server 2008 using windows server 2008.

    I’m looking for any kind of benchmark that could help me to determine the expected latency.

    Did you seen any kind of benchmark or analysis plan for latency?

    the only interesting articles I found was 2005 vs 2008.
    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd263442(v=sql.100)

    or How can I determine if peer-to-peer can handle the number of transaction my server handle?

    Thanks,

    Reply
  • Abdul manzoor
    April 1, 2013 5:44 pm

    Hi Pinal,

    i am getting the following error on SQL 2008

    The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.

    Thanks
    Abdul

    Reply

Leave a Reply

Menu