Home  |  My Account  |  Shopping Cart (0 items)   
Login/Signup  |  Help  |  Contact Us  
Search for Books:       Advanced Search
Advance Search Cancel
Title : Author :
From Date To Date
Publisher : ISBN Number :
Category : Price : From To

Pro SQL Server 2008 Replication-Sujoy Paul
Pro SQL Server 2008 Replication  
by Sujoy Paul (Author)
Customer Reviews (0) | Write a Review
Publisher : Apress-1
Publish date : 22-Jun-2009
Category :
Mediatype :
Binding : Paperback
Availability : IsAvailable, Order now ships within 5-7 business days
List Price :   Rs. 899
Greenleaf Price :  Rs. 764
You Save :  Rs. 135
ISBN : 9781430218074 / Indian ISBN 13: 9781430218074
Pages : 936
Book Summary : Pro SQL Server 2008 Replication

Pro SQL Server 2008 Replication is for MS database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and

  • Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication.
  • Examines the detailed configuration and the internal workings of the different replication types using real–life scenarios
  • Covers replication with database mirroring and troubleshooting
  • Discusses replication administration using different tools

What you’ll learn

  • Configure hierarchical replication: snapshot, transactional and merge, and heterogeneous replication using real–life scenarios.
  • Gain insight into the internal workings of the different replication types.
  • Master the usage of different tools like tablediff, SQLCMD, DTA, and Replication Monitor in administering replication.
  • Perform administration tasks such as backup and recovery, and manage replication with other high–availability techniques like database mirroring and log shipping.
  • Conduct optimization and tuning of replicated databases.
  • Develop troubleshooting techniques.

Who this book is for
Set up a stand–alone Hadoop cluster the smart way, laid out simply and step by step so you can get up and running quickly to build your next data center, collaborative, data–intensive Internet services application, Software as a Service (SaaS), and more.

Table of Contents

  • Introduction
  • Replication Basics
  • Types of Replication
  • Configuring Snapshot Replication Using the GUI
  • Configuring Snapshot Replication Using T-SQL
  • Snapshot Generation
  • Internals of Snapshot Replication
  • Configuring Transactional Replication Using the GUI
  • Configuring Transactional Replication Using T-SQL
  • Internals of Transactional Replication
  • Configuring Merge Replication Using the GUI
  • Web Synchronization with Merge Replication
  • Configuring Merge Replication Using T-SQL
  • The Internals of Merge Replication
  • Backup and Recovery of Snapshot and Transactional Replication
  • Backup and Recovery of Merge Replication
  • Optimizing Snapshot Replication
  • Optimizing Transactional Replication
  • Optimizing Merge Replication
  • Heterogeneous Replication

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).

Contact Us
Shipping & Returns
Help & FAQ
Terms of Use
About Us
About us
e-Gift Voucher
Book List
Author List
Search for Books :
© 2010 Greenleaf Bookshop. One Stop Shop for all your Books,CBT's, DVD's