I optimize the speed, efficiency, and stability of SQL Server.
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.
Now, if there is an outage covering the entire server region, you can use the Geo-Restore feature or the Geo-replicati...
Forgot my SA password, and I don't have sysadmin rights...
December 10, 2018
Page Splits, should I worry?
August 8, 2018
Capture Query Information with Extended Events
July 30, 2018
DBCC CheckDB on a large Database
July 24, 2018
New TempDB TraceFlag
July 19, 2018
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.
High Availability (6)
Disaster Recovery (5)
Performance Tuning (12)
Professional Development (1)