• 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 2, 2018

It's becoming less surprising, but no less scary when I find shops not taking regular database backups. This happens quite often in situations where there is no dedicated DBA. Meaning someone else just kind of took over those responsibilities ("accidental DBA", if you...

December 13, 2017

It is unbelievable how common it is to walk into a new organization only to find that they have no database backups. But when having a conversation with management, they expect zero data loss.  Seems like a bit of a conundrum don't you think?

It's important to bring abo...

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

November 1, 2017

Before we begin:

While the gui/wizard for setting up Availability groups is super easy, I'm going to go through utilizing T-SQL. This gives us an "Under the hood" look at the way these are setup. I will provide the full script at the end of the post.

As an FYI, I will be...

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

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