Buy new:
-37% $18.84
FREE delivery Friday, May 17 on orders shipped by Amazon over $35
Ships from: Amazon.com
Sold by: Amazon.com
$18.84 with 37 percent savings
List Price: $29.99

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Friday, May 17 on orders shipped by Amazon over $35
Only 1 left in stock - order soon.
$$18.84 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$18.84
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
30-day easy returns
30-day easy returns
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
30-day easy returns
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$12.40
Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc... Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc... See less
$3.98 delivery May 20 - 21. Details
Only 1 left in stock - order soon.
$$18.84 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$18.84
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by glenthebookseller.
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Sebastian Meine
+ Follow
More books from this author
Something went wrong. Please try your request again later.

Fundamentals of SQL Server 2012 Replication

by Sebastian Meine (Author)
4.4 4.4 out of 5 stars 19 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$18.84","priceAmount":18.84,"currencySymbol":"$","integerValue":"18","decimalSeparator":".","fractionalValue":"84","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"Amvjj38ye0VX2iYs9r0FjyZWXcophT84cNDnAaXgOYr0dAP%2FLGMOke00Q3dgDwtt98YOc988GWm1CMARwqLYcWdScvyw99HBu2ekae3mpjyy8ijs5EO40bEUyMT%2B5FfX3shiY8csFYelG2jWVEtWHg%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$12.40","priceAmount":12.40,"currencySymbol":"$","integerValue":"12","decimalSeparator":".","fractionalValue":"40","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"Amvjj38ye0VX2iYs9r0FjyZWXcophT84Pf5uOPJqO565NjhNPbPG9kvI2xv%2FqsbDCLW%2BHOjFr%2BgdHvSYP3DOqb6fQTG7GOgQRv3cyxWKY%2BPxiqjdHxkLAf3SQ5jEZ03ukdpcndKEjLP5G0DQJkXVD1sI0KlBkvWIJwJfB78lSg%2FLmh1rSMvbenaLaRTq0fHB","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

It is a common requirement to make data that lives on one server available on another. You might want to speed up cross-server queries by providing a local copy of the data. You might want to make the data available to resource intensive reporting queries without affecting the OLTP load, maybe even with an intentional delay in synchronization, so that reports run against complete days only. You may wish to replicate a complete database to a secondary 'standby' server for high availability. In each case, SQL Server Replication is a viable option, and Fundamentals of SQL Server 2012 Replication provides the hands-on introduction you need to get started, and explores all of the technology's most important strengths and weaknesses. It will help you make an informed decision on whether replication is the right feature for your requirements, and on which type of replication most appropriate. Equally, it offers guidance on when to avoid replication in favor of features such as simple log shipping, or the "Always On" feature set. This is a practical guide, with all major concepts illustrated with exercises.
Read more Read less
Previous page
  1. ISBN-10
    1906434999
  2. ISBN-13
    978-1906434991
  3. Publisher
    Red Gate Books
  4. Publication date
    August 27, 2013
  5. Language
    English
  6. Dimensions
    7.5 x 0.78 x 9.25 inches
  7. Print length
    376 pages
  8. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Product details

  • Publisher ‏ : ‎ Red Gate Books (August 27, 2013)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 376 pages
  • ISBN-10 ‏ : ‎ 1906434999
  • ISBN-13 ‏ : ‎ 978-1906434991
  • Item Weight ‏ : ‎ 1.42 pounds
  • Dimensions ‏ : ‎ 7.5 x 0.78 x 9.25 inches
  • Customer Reviews:
    4.4 4.4 out of 5 stars 19 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Sebastian Meine

Sebastian Meine

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). After receiving his PhD in Computer Science at the University of Linz, Austria he spent several years at a global Fortune 50 company as software architect responsible for code quality and performance of dozens of large-scale database installations nationwide.

In 2010, to fully engage in his passion for SQL Server, he founded sqlity.net. Since that time he has been helping his clients to boost their SQL Server health, enhance their T-SQL coding skills and tighten their SQL Server security.

Sebastian is a sought-after trainer, speaker and author who shares his knowledge regularly within the world-wide SQL community through his writings and public speaking engagements. Additionally he is coauthor of tSQLt, the Database Unit Testing Framework for SQL Server. tSQLt is open source and available at http://tSQLt.org.

Sebastian is also the CTO of TSTS Inc., a company that provides online personalized training and workout solutions.

Customer reviews

4.4 out of 5 stars
4.4 out of 5
19 global ratings

Top reviews from the United States

Glen Cooper
5.0 out of 5 stars Outstanding book
Reviewed in the United States on November 1, 2013
Verified Purchase
Book Review
Fundamentals of SQL SERVER 2012
Sebastian Meine, Ph.D.

This book was a pleasure to read.

Sebastian offers a breezy introduction to SQL Server 2012 replication that touches on all the main points. And it was well edited - you won't stumble across any typos or grammar errors (nice). He carefully explains subtleties, like security, without overwhelming the reader with a lot of jargon.

After providing an overview of replication in general (publisher, distributor, subscriber, push vs. pull, replication agents etc.) the book handles transactional replication in detail before examining merge replication and the differences between the two.

Exercises are everywhere, so you can build his replications on your own servers while reading the book.

This book has chapters devoted to the distributor, publication access list, SQL Server Agent jobs, conflict resolution for merges, and replication monitor. These are important subjects in their own right, and he has emphasized that importance by these sections.

But an additional chapter on using the more limited SQL Server Express would be welcomed.

Sebastian concludes with a section on troubleshooting, which is really important since replication errors can be difficult to interpret.

Who should buy this book?

Anyone who knows SQL Server basics (but wants to replicate) would be well-served by reading this book before digging into BOL.
Helpful
 Report
tyler
5.0 out of 5 stars Just What I Needed
Reviewed in the United States on July 12, 2022
Verified Purchase
Good solid book on the fundamentals of Sql. Though written almost 10 years ago, the core concepts are as relevant as ever. Highly recommended
Helpful
 Report
Chang-ping Hsiao
4.0 out of 5 stars This books will help readers new to replication to start right away.
Reviewed in the United States on July 8, 2014
Verified Purchase
Very detailed steps allow readers to comprehend easily.
However, this book looks more like a notepad document rather than a book.
Helpful
 Report
Tousg
5.0 out of 5 stars Gift
Reviewed in the United States on July 1, 2019
Verified Purchase
Who knows if they liked or or even used it
Helpful
 Report
Amazon Customer
3.0 out of 5 stars Found out this is available for free in pdf form
Reviewed in the United States on January 21, 2020
Verified Purchase
Paid what I thought was a reasonable price for this, but found later it's available in PDF form for free. It's a good resource for learning about Replication and applies to more than SQL 2012 as replication hasn't changed much over the years.
One person found this helpful
Helpful
 Report
Almond Joy
5.0 out of 5 stars Great introduction to replication
Reviewed in the United States on February 21, 2014
Verified Purchase
The writer really knows his stuff. I am someone using SQL server for years but never used replication, this is a great introduction with clear explanations for this important feature of SQL server.
Helpful
 Report
Anand
5.0 out of 5 stars Excellent Compact Book for Advanced SQL Server Developers
Reviewed in the United States on January 7, 2014
Red Gate recently released Fundamentals of SQL Server 2012 Replication authored by Dr. Sebastian Meine and it contains 14 chapters. While chapter 1 provides an overview of SQL Server Replication, Chapter 2 examines the steps required to configure basic replication setup such as setting up the distributor, publication and subscription.

Chapter 3 examines the role of the distributor including the best practices to be followed. Chapters 4 & 5 provide an overview of replication agents and transactional replication related to publication. The author examines the steps related to configure publication access list in chapter 6.

You will learn transactional replication aspects related to subscription in addition to configuration of retention. The next chapter covers SQL Server agent jobs such as snapshot, log reader, distribution and replication maintenance in addition to the coverage of the steps related to create SQL Server agent jobs.

Chapters 9, 10 and 11 examine merge replication aspects related to replication agents, publication, subscription and conflicts. Chapter 13 provides coverage of the usage of replication monitor. Among other concepts you will learn the steps required to view information about a publisher, transactional publications, merge and snapshot publications.

The author has provided detailed step-by-step explanation along with relevant screenshots in addition to diagrams, screenshots and source codes. In the final chapter, you will learn the steps related to troubleshoot publication, subscription including coverage of tracer tokens and date problems.

Fundamentals of SQL Server 2012 Replication will be useful for database administrators, SQL Server trainers and for those developers who would like to explore advanced techniques associated with SQL Server.
3 people found this helpful
Helpful
 Report
Kindle Customer
4.0 out of 5 stars great book for replication beginners
Reviewed in the United States on September 22, 2014
Verified Purchase
It is a great book for replication fundamentals but after all i needed more advanced section
Helpful
 Report

Top reviews from other countries

Ramdas Baghel
1.0 out of 5 stars Ramdas Baghel
Reviewed in India on October 25, 2013
Verified Purchase
I read this book. I found this is very basic book on SQL Server Replication, well written for beginners.
Title of this book "Fundamentals of SQL Server 2012 Replication" confusing because in whole book there is no information about what new in SQL Server 2012 replication or even there is no discussion about SQL Server version 2012 & replication.

Again I like this book and suggest for beginners.

Thanks you Sebastian & Kalen Delaney as technical reviewer.
Report