Great Article Peter, However It would have been good to do a performance benchmark between Azure and Amazon RDS using the same Database (loaded with sample data to different size points) and apply a work load file against it.
From Experience Azure seems average for speed but makes it rather hard to connect to as a non developer. The fact that Amazon RDS connects simply with SSMS is a great selling point for me, but at what cost (i.e security). Not to mention most Amazon services have a high network latency (from Sydney Aus) compared to Azure.
Thank you, yes I am about to do some benchmarking for a client comparing the performance of both Azure and AWS. I intend to run a few different VM sizes for both and with AWS I will be able to try different sizes of database server. We’re hoping we’ll get permission to share the results back via a follow-up article.
Definitely being able to connect into RDS via SSMS from anywhere will be a big selling point for many people. It’s a matter of getting the best compromise between convenience and security.