I optimize the speed, efficiency, and stability of SQL Server.
September 19, 2017
While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency of powershell. Building off of my previous posts, I'm going to provide a few powershell commands to login and create a new Azure SQL Database.
The first step allows you...
July 24, 2017
Azure provides built in high availability. In a given server region, you are provided with three local copies of the Azure SQL Database.
Now, if there is an outage covering the entire server region, you can use the Geo-Restore feature or the Geo-replicati...
July 10, 2017
One of the great things about Azure is that backups are automated as part of the service. Azure for SQL touts a 12 hour RTO and a 5 minute RPO for backups that are considered "in-region".
The backup schedule is as follows:
June 30, 2017
Going to the Azure Portal, creating our first SQL Database.
June 27, 2017
If only I could upload my brain to the cloud. BaaS anyone?
What is Database as a Service (DaaS)?
Azure SQL Database is Microsoft's version of DaaS.
DaaS is a cloud service in which the service provider manages the operating system and database software. In addition to th...
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)