Tags » AlwaysOn

SQL Server AlwaysOn Revealed

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. 60 more words

Other

AlwaysOn – Endpoint Ownership

— By Ginger Keys

It is not uncommon for a DBA or other IT staff to set up AlwaysOn in a SQL environment and later leave the company. 544 more words

SQL Server

Disaster Recovery Using AlwaysON Availability Group – Scenario 2

Environment

-> Disaster Recovery scenario is as below,

  • PRIMARY DATA CENTRE goes down.
  • The databases on Server JBSERVER2 should be made online and have the application connect to Database Server JBSERVER2.
  • 408 more words
AlwaysON

Disaster Recovery Using AlwaysON Availability Group – Scenario 1

Environment

-> Disaster Recovery scenario is as below,

  • PRIMARY DATA CENTRE goes down.
  • The databases on Server JBSERVER2 should be made online and have the application connect to Database Server JBSERVER2.
  • 414 more words
AlwaysON

Availability Groups / Service Broker Transmission Queue Bug Fix

An issue exists in SQL Server 2012 SP1 CU6 Availability Group Primary databases involved in Service Broker conversations. If you reused conversations and failover mode is set to manual… 1,217 more words

AlwaysOn

How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to configure Transparent Data encryption (TDE) using asymmetric key protection with Azure Key Vault with… 15 more words

SQL 2016

MSSQL Server AlwaysON (Get alerted for inconsistencies in logins, jobs and databases)

Introduction
There can be times during a typical day of a DBA, when there are a lot of urgent requests coming and the DBA is busy resolving issues. 2,994 more words

MS Azure