THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Sergio Govoni

A place where share my experience on SQL Server and related technologies

Fundamentals of SQL Server 2012 Replication

From Red-Gate web site you can download, for free (plus a trial of SQL Monitor), the eBook Fundamentals of SQL Server 2012 Replication written by Sebastian Meine (@sqlity).

Data replication is traditionally considered a complex feature and generally we get discouraged easily, already during the preparation of the test environment. Why the implementation of a SQL Server Replication is considered a complex activity? Which problems could you meet? The most common problems that you could encounter are related to the database schema that it has to be thought for replication scenarios and there could be problems related to the replication agents' permissions. Finally, you may encounter problems related to the architecture of the network and the Internet bandwidth especially if you want to implement a web replication or if you have to use an ftp area for data exchange. To do a good job, we need different skills.

This book cannot miss in your digital library! And obviously you can buy the paperback on Amazon.

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.


Enjoy the book!

Published Wednesday, November 13, 2013 11:05 PM by Sergio Govoni
Filed under: , ,

Comments

No Comments
Anonymous comments are disabled
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement