FREE PDF

eBook

Fundamentals Of SQL Server 2012 Replication

Download free PDF

Download your free eBook.

About the eBook

by Sebastian Meine

Buy from Amazon.com
Buy from Amazon.co.uk

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

Share

  • Twitter
  • Facebook
  • Google+
  • LinkedIn

You may also like

eBook

How to become an Exceptional DBA, 2nd edition

This book is a career guide that will show you, step-by-step, specifically what you can do to differentiate yourself from the crowd, so…

eBook

SQL Server Statistics

Reading Holger's booklet is a great way of brushing up on the subject of Statistics and query-optimization. It is reasonably short…

Blog post

Managing Environments in DLM Dashboard

Find out how to set up DLM Dashboard to better reflect your own environment, view only the categories you care about, and make sure...