I optimize the speed, efficiency, and stability of SQL Server.
January 9, 2018
Sometimes for testing purposes (or an emergency) one might find it useful to remove query plan for a single stored procedure. This way you won't have to disrupt the entire instance (and possibly anger your fellow developers!).
I often forget that DBCC FREEPROCCACHE acce...
December 19, 2017
I know, it sounds like it could be a desert. But it's poison!
You ever have one of those Saturday morning emergencies and come face to face with a wait type that you're completely unfamiliar with?
I recently got contacted that a highly transactional SQL Server was per...
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)