SQL Server AlwaysOn Revealed

Authors: Carter, Peter A.

Download source code
  • Covers a new and high-end feature set that is sweeping the user community
    Provides a quick start to 24x7 availability in support of enterprise applications
    Helps database administrators ensure their ability to recover from data loss

Buy this book

eBook $9.99
$19.99 (listprice)
price for USA (gross)
valid through November 28, 2017
  • ISBN 978-1-4842-1763-4
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
About this book

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter’s Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.

Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.

SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.

  • Teaches you to build HA and DR solutions using the AlwaysOn feature set
  • Provides real-world advice on configuration and performance considerations
  • Demonstrates administrative techniques for the AlwaysOn feature set

What You Will Learn

  • Understand high availability and disaster recovery concepts and terminology.
  • Understand the technologies available, to implement HA and DR.
  • Build and configure a Windows Cluster.
  • Build and configure an AlwaysOn failover clustered instance.
  • Implement AlwaysOn Availability Groups and appropriately configure them.
  • Administer AlwaysOn technologies post implementation.

Who This Book Is For

SQL Server AlwaysOn Revealed is for database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

 

About the authors

Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and it sits alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005 onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.

Table of contents (6 chapters)

  • High Availability and Disaster Recovery Concepts

    Carter, Peter A

    Pages 1-6

  • Understanding High Availability and Disaster Recovery Technologies

    Carter, Peter A

    Pages 7-26

  • Implementing a Cluster

    Carter, Peter A

    Pages 27-56

  • Implementing an AlwaysOn Failover Clustered Instance

    Carter, Peter A

    Pages 57-69

  • Implementing AlwaysOn Availability Groups

    Carter, Peter A

    Pages 71-128

Buy this book

eBook $9.99
$19.99 (listprice)
price for USA (gross)
valid through November 28, 2017
  • ISBN 978-1-4842-1763-4
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
SQL Server AlwaysOn Revealed
Authors
Copyright
2015
Publisher
Apress
Copyright Holder
Peter A. Carter
eBook ISBN
978-1-4842-1763-4
DOI
10.1007/978-1-4842-1763-4
Edition Number
1
Number of Pages
XIII, 150
Number of Illustrations and Tables
100 b/w illustrations
Topics