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.
Reading the Deadlock Graph
Deadlocks: Alerting and Information Collection
Powershell: Create Azure SQL Database
Script to Kill Blocked Processes
Powershell: Stop SQL Server Cluster Resource
SQL Cruise Alaska 2017 Recap
Powershell: Failover a SQL Service in a Failover Cluster
Automate SQL Server Install
Book Review: SQL Server Query Performance Tuning by Grant Fritchey