Comment Re:And it's gonna rain (Score 1) 83
As for AWS vs Azure performance, I'm not sure how you were testing but based on your "expert" opinions which are sorely misinformed, I'm guessing you did something really boneheaded. A P3 instance is set to give a minimum of 735 IOPS every second. So if you were getting less than one, I'd say that was a problem with the user. We use Azure to run our production sites and haven't seen anything of the sort you describe.
On Azure, SQL databases can be connected to from anywhere, any IP. There is no firewall at all.
Uh, no. You have to explicitly allow IPs in. Here's a link to "Azure SQL Database Firewall": https://msdn.microsoft.com/en-...
If you don't understand firewalls, there is a pretty picture if you scroll down. The first step "SQL Database Firewell" is a server-level IP firewall. Yes, the configuration is stored in the database, but that has very little meaning, it could have been stored in a
I've never tried a D14 VM with enterprise installed, but if you were getting poor performance, I'm guessing you did something extremely boneheaded like try to put the database on a remote drive instead of the local SSD.