I optimize the speed, efficiency, and stability of SQL Server.
August 8, 2018
I wish page splits were delicious.
What are page splits?
Page splits occur when a data page gets filled with data and a new page is needed to make room for new data. There are times when data modification causes data to be inserted in the middle of a page, this causes...
July 30, 2018
Many of us have not made the effort to switch from profiler to Extended events. It's 2018, if you haven't found a few hours to learn about this incredibly powerful tool, I urge you to do so now.
I'm going to provide a quick means of tracking queries with extended...
Forgot my SA password, and I don't have sysadmin rights...
December 10, 2018
Page Splits, should I worry?
Capture Query Information with Extended Events
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)