I optimize the speed, efficiency, and stability of SQL Server.
Forgot my SA password, and I don't have sysadmin rights...
Page Splits, should I worry?
Capture Query Information with Extended Events
DBCC CheckDB on a large Database
New TempDB TraceFlag
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.
Availability Groups and Session Timeouts across WAN?
Does SQL Server need more memory? Page Life Expectancy
How do I encrypt Social Security Numbers in SQL Server?
Use Cases for Query Store
No Backups, No Logs, No Dice...
Query Store Overview