#2 Glancing at Microsoft's Azure Synapse web page, it appears to be a database in the cloud.
Having worked with both Microsoft and Oracle, I'd recommend Oracle over Microsoft.
And from what I can gather about this "cloud" thingy, it's customers accessing Microsoft's disk storage over the internet. So, IOW, you put your database on Microsoft's disks and access it over the internet.
I count at least two major vulnerabilities there: 1) the disks are owned and operated by Microsoft, 'nuff said, and 2) your data is flapping out on the internet like underwear drying on a clothes line. You never want your mission critical database directly exposed to the internet especially if you're relying on Microsoft to keep it secure.
I recently installed a one terabyte solid state hard drive on my computer. It was about the size of a baseball card. That's an obscene amount of storage. When I used to work for a mid-sized company we could have put four instances of our Oracle database on this one little disk without any need for striping over multiple old style spinning disks. Why then, would we ever need a cloud? |