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.
Query Store Overview
Clear cache for a single Stored Procedure
The importance of RPO and RTO
Using Diskspd To Test Storage
Use DBATools Powershell module for Migrations
TSQL Tuesday: Folks Who Have Made a Difference
AlwaysOn Series: Monitoring with SQL Agent Alerts
Partition Tables in SQL Server