#AlwaysOn

FOLLOW ME:

RECENT POSTS:

Forgot my SA password, and I don't have sysadmin rights...

Page Splits, should I worry?

Capture Query Information with Extended Events

DBCC CheckDB on a large Database

New TempDB TraceFlag

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server. When not working I like to lift weights, play music, and travel with my wife.

Availability Groups and Session Timeouts across WAN?

What is a session timeout? This is a property that dictates how many seconds an availability replica waits for a (ping) response from...

How do I encrypt Social Security Numbers in SQL Server?

So, your manager wants you to figure out how to encrypt sensitive Data? Well Microsoft has introduced a fairly easy way to configure...

AlwaysOn Series: Monitoring with SQL Agent Alerts

There are several ways to monitor your Availability Groups using native SQL tools. In this particular article I'm going to cover a few...

Build an AlwaysON Availability Group Part 1: Build the Windows Failover Cluster

Build the cluster right so you don't run around frantically like this guy does for a living. So most DBA's know that AlwaysOn...

Cloud Series: High Availability in Azure SQL

Azure provides built in high availability. In a given server region, you are provided with three local copies of the Azure SQL Database....