I optimize the speed, efficiency, and stability of SQL Server.
December 5, 2017
It's important to test your storage performance especially prior to installing or deploying a new SQL Server.
Microsoft has provided us with a great tool called Diskspd, which was meant to replace SQLIO. Diskspd synthetically generates workloads to run against your ser...
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)