Pro SQL Server 2005 Replication

Pro SQL Server 2005 Replication

by Sujoy Paul

Paperback(Softcover reprint of the original 1st ed.)

$82.98 $94.99 Save 13% Current price is $82.98, Original price is $94.99. You Save 13%.
View All Available Formats & Editions

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Overview

Pro SQL Server 2005 Replication by Sujoy Paul

Replication is a way of copying and updating information in a database. The Definitive Guide to SQL Server 2005 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2005. The book will also delve into advanced topics like replication of SQL Server with heterogeneous databases; replication of different database objects like stored procedures; backup and recovery of replicated databases; performance and tuning; and finally troubleshooting replication. As such, this book will address the concerns of both novice and advanced users of replication.

Product Details

ISBN-13: 9781484220283
Publisher: Apress
Publication date: 04/30/2017
Edition description: Softcover reprint of the original 1st ed.
Pages: 996
Product dimensions: 7.01(w) x 9.25(h) x (d)

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). He is the author or coauthor of dozens of technical papers, including ""Replicating SQL Server 2000 across Heterogeneous Databases"" (SQLTeam.com, August 2003).

Table of Contents

A table of contents is not available for this title.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Pro SQL Server 2005 Replication 4.5 out of 5 based on 0 ratings. 2 reviews.
Guest More than 1 year ago
This book helps in developing a replication system for those who will implement it and needs a complete reference to be used as a guide. It has a lot of detailed information for beginners but certainly covers intermediate and senior levels questions. Excellent reference to check any step you may not miss, with screen pictures, explanations of why we¿d need to perform such action. Another valuable point found in the book is: the tips, the cautions and the notes that we easily understand that certainly it¿s a plus for the chapter and the subject. With so many replication system options that we have, the author included a chapter that covers heterogeneous environments. The information available in the book is very clear, organized, consistent and very well presented. Regarding the transactional replication, the author wasn¿t only worried in showing how to configure using GUI or T-SQL, he also released a whole chapter explaining the internals which is extremely good for those technicians who want to troubleshoot and also autonomy to manage and understand the transactional environment. I strong recommend the book for the tech crew from beginners in replication systems to seniors who want to review their knowledge and possibly apply new rep strategy. I also would like to see a chapter about troubleshooting.
Guest More than 1 year ago
Pro SQL Server 2005 Replication has extensive material that explains from start to end complete database replication.Author Sujoy has done a good job touching all the new concepts in SQL Server 2005. The book is a good learning and implemented material that has all the easy to implement topics to troubleshoot any replication errors. Chapter 1 has very good introduction about Distributed data. Replication basics and types of replication provides detailed information and it helps to educate the user. Chapter 4 and chapter 5 which explains aout snapshot replication using GUI and T-SQL covered sqlserver 2005 new GUI. Chapter 8 and 9 has covered transactional replication using the GUI and T-SQL.The internals of Transaction replication is well explained with author's experiece and it has good introductory about internals of transactional replication. The web synchornization with merge replication and configuring merge replication using t-sql is very hands on sql. Backup and Recovery of merge replication is a very good added resoruce for DBAs to developers.Optimization is one very importnat cocepts that has been handled well. on overall,I recommend this book to software professional from starters to sernior programmers who use SQL Server and other database products.