I optimize the speed, efficiency, and stability of SQL Server.
July 10, 2018
So, your manager wants you to figure out how to encrypt sensitive Data? Well Microsoft has introduced a fairly easy way to configure feature called Always Encrypted.
What is it?
Always Encrypted was introduced in SQL Server 2016. It is an encryption feature that is inten...
February 26, 2018
If you're storing any of your database backups off site or in the cloud, you might want to look into encrypting your backups. This feature was first introduced in SQL 2014.
Since we're working with encryption on SQL server the first step is to create a Database Master k...
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)