Josh Darnell looks at the options for running SQL Server in Azure:
Things are always changing the cloud, but as it stands in early 2020, these are the main options for SQL Server in Azure:
– SQL Virtual Machines
– Managed Instances
– Databases (this one really has a number of sub-options, like serverless, hyperscale, and elastic pools)I’m going to touch on each of these options, why you might choose them, and some of my personal takeaways from the talk as well.
Read on for the summary of each. Each one fills a different set of needs and has a different set of available options.