I optimize the speed, efficiency, and stability of SQL Server.
November 14, 2017
Today's post was prompted by SQL On Ice. He proposed that we take this week's TSQL Tuesday to show our appreciation of people who have helped us. I've said it before, in my recap for SQL Cruise, that one of the best things about working with SQL Server is the community...
November 7, 2017
This post is meant to be a quick primer on Table Partitioning in SQL Server.
What is it?
Let's say you have a large table that is accepting a lot of transactions, partitioning allows you to scale this particular table out into different (physical partitions). Thus sprea...
August 8, 2017
Is this where clusters go when they die?
A great way to test failover or to simply move disable a clustered SQL Service is to utilize powershell. You can create a script and hand it over to the server team or you can schedule it.
Most of the time certain cluster mainten...
Forgot my SA password, and I don't have sysadmin rights...
December 10, 2018
Page Splits, should I worry?
August 8, 2018
Capture Query Information with Extended Events
July 30, 2018
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)