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.
Clear cache for a single Stored Procedure
TSQL Tuesday: Folks Who Have Made a Difference
Partition Tables in SQL Server
Build an AlwaysON Availability Group Part 2: Setting up SQL Server and Adding a Database
Build an AlwaysON Availability Group Part 1: Build the Windows Failover Cluster
Deadlock Error Handling
Script to Kill Blocked Processes