|
Pro SQL Server 2008 Replication |  | Author: Sujoy Paul
Publisher: Apress
Category: Book
List Price: $79.99
Buy New: $29.01
as of 7/29/2010 05:13 CDT details
You Save: $50.98 (64%)
New (17) Used (17) from $22.99
Seller: best_bargain_books3
Rating:  4 reviews
Sales Rank: 182187
Media: Paperback
Edition: 1
Pages: 936
Number Of Items: 1
Shipping Weight (lbs): 2.7
Dimensions (in): 9.3 x 7.1 x 2.1
ISBN: 143021807X
Dewey Decimal Number: 005
EAN: 9781430218074
ASIN: 143021807X
Publication Date: June 22, 2009
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
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 is this book for? This book is a comprehensive guide for experienced users of SQL Server as well as new users. It also aims at familiarizing the current users of SQL Server 2005 with the new features of replication should they upgrade to SQL Server 2008. This book will delve into the basics of replication like the publisher–subscriber model, the different replication types (such as snapshot, transactional, merge, and heterogeneous), the corresponding architecture, implementation, and administration. Database administration tasks like backup and recovery, managing replication with high–availability techniques like database mirroring, log shipping with replication, and optimization of replicated databases will also be discussed. This book will benefit primarily novice and intermediate users by introducing replication and the different processes and then building on the basics to develop and address the advanced features of replication. This is a must–have companion book that will help you in developing, administering and mastering the intricacies of replication. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.
|
| Customer Reviews:
 A good reference book.... January 12, 2010
Sudheer K. Maharana
Are you new to SQL Server replication in SQL Server 2008? Or are you experienced enough in SQL Server replication? If so..this is the book for you. The book is organized very well. It first gives you the basics of each type of replication, goes on to describe on how to configure replication in 2 different ways: GUI and T-SQL. I always preferred to use T-SQL for various reasons. It is easily deployable in different database environments and the scripts can be backed up as normal SQL scripts.
I liked all the "internal" and "optimization" chapters on each type of replication. The author has described these chapters well. The book also gives a step by step approach to configure the replication which helps. However, I expected some more details on replication monitoring, replication security/permissions and providing some real world scenarios on replication troubleshooting. I guess there are so many books out there on SQL Server replication but these advanced topics would have made the quality of this book even better.
I will give this book a 4 star and would highly recommend DBAs to refer this book when they are in need of configuring replication.
 Not much help if you are in a production environment... December 29, 2009
Michael Hestness (Bellevue, WA USA)
2 out of 2 found this review helpful
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.
 confusing figures October 16, 2009
F. van der Geer (Rotterdam, Netherlands)
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.
 Comprehensive Resource September 9, 2009
T. Anderson (PA USA)
This is one thorough reference. It begins with an introduction to distributed data, distributed data transactions, eager replication, lazy replication, replication in SQL server, and the benefits of replication.
The book then covers replication basics including the published-subscriber model, the different components of replication, physical replication models, and installing and configuring replication.
Next is a detailed chapter on the types of replication, which include snapshot replication, transactional replication, and merge replication.
Then there are several chapters on configuring snapshot generation, transactional replication, and merge replication. Each is covered with a chapter on configuring with a GUI, configuring using T - SQL, and the internals of each type of replication. Merge replication also includes a chapter on web synchronization with merge replication.
After that backup and recovery, and optimizing, are covered for each type of replication.
The book ends with a chapter on heterogeneous replication and how to connect with oracle to do replication.
There are a ton of screenshots and a lot of code. This allows you to read the book without having a computer nearby to look at the examples in full. The book also contains a lot of tables which give great snapshots of the different parts involved with replication.
There is a code download. The download includes text files for each chapter which contains the code samples for that chapter.
The book is very well organized and has a very logical flow to it. The author also has a good writing style which makes reading a book on merge replication, which usually would not be too pleasant, a very enjoyable read.
All in all I do not think there is a more comprehensive resource for information on how to accomplish replication in a real-world production environment.
I highly recommend this book to anyone involved with replication in SQL server 2008.
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
