• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

July 17, 2018

What is a session timeout?

This is a property that dictates how many seconds an availability replica waits for a (ping) response from another replica in the Availability Group considering the connection to have timed out and thus failed.

The default settings is set to te...

July 10, 2018

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

What is it?

Always Encrypted was introduced in SQL Server 2016. It is an encryption feature that is inten...

November 9, 2017

There are several ways to monitor your Availability Groups using native SQL tools. In this particular article I'm going to cover a few SQL Agent Alerts that I have used in the past. 

Let's first identify some of the error numbers we will be referencing.

Error 1480 - Indi...

October 27, 2017

 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 Availability groups were introduced in SQL 2012.  I know it was the most exciting feature for me a few years ago and I couldn't wait to impleme...

July 24, 2017

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

Geo-Replication

Now, if there is an outage covering the entire server region, you can use the Geo-Restore feature or the Geo-replicati...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

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.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle