Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Fundamentals of SQL Server Replication by Sebastian Meine

By Sebastian Meine,

Available from: Amazon US $21.72 | UK £19.99

Editorial Review

Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implemen­tation of such a requirement.

With this book, I want to introduce you into the vast world of SQL Server Replication and show you its most important strength and weaknesses. After working through the exercises, you will be able to make an informed decision whether replication is the right feature to use and which type of replication is the most advantageous in your situation. You will also know when to stay away from replication and use other features such as simple log shipping or the new "Always On" feature set.

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book begins with a short overview that introduces you to the technologies that make up replication. In the following chapters, the book will walk you through setting up different replication scenarios. All hands-on exercises are designed with security best practices in mind. When you're finished working through the exercises, you will be able to implement your own multi-server replication setup while following the principle of least privilege.

About the Author

Sebastian Meine, PhD is a principal trainer and consultant with sqlity.net llc. He specializes in T-SQL performance and SQL-TDD and shares his passion and knowledge regularly with audiences world-wide.

Publisher: Red Gate Books

Total article views: 5609 | Views in the last 30 days: 63
 
Related Articles
ARTICLE

AlwaysOn Availability Groups in SQL Server 2012

This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new featu...

BLOG

Denali – Day 30: Deprecated Features

Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the cu...

ARTICLE

High Availability (DR) Using SQL Server 2005 Transactional Replication

One of the four high availability technologies in SQL Server is replication, though this can be very...

FORUM

SQL Server Features

SQL Server Features Implemented

FORUM

High availability

High availability

Tags
books    
replication    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones