I optimize the speed, efficiency, and stability of SQL Server.
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...
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)