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

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

August 8, 2017

Is this where clusters go when they die?

A great way to test failover or to simply move disable a clustered SQL Service is to utilize powershell. You can create a script and hand it over to the server team or you can schedule it. 

Most of the time certain cluster mainten...

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