I optimize the speed, efficiency, and stability of SQL Server.
July 5, 2018
Why should I use Query Store?
Query store can be used for a number of things. For example:
Find out what was happening on my server last night?
Identify and fix queries suffering from parameter sniffing or plan regression
Testing (ie - when upgrading to a...
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)