Introduction to Azure SQL Managed Instance – SQL on the edge episode 17
SQL Server is one of the most adopted and widely-used database engines in the world. Almost every company either builds on it or uses some enterprise third-party software that uses it as the back end. For this reason, it makes sense that Microsoft has invested in their SQL database offering in Azure from the initial years of the cloud platform. Looking at the timeline of SQL-related Azure releases, we can also see that in the last few years, Microsoft has aggressively increased these investments to provide customers with more choice and more power. Let's see:
- Azure SQL Database was released in 2010.
- Performance-based tiers released in 2014.
- Elastic Pools released in 2015.
- Azure SQL Data Warehouse released in 2016.
- Azure SQL Managed Instance in preview now, H1 2018.
- Cores: the amount of cores will also dictate how much RAM you get.
- Data Storage: the first 32GB are included, then you pay in 32GB increments.
- Backup Storage: the amount in GB of your compressed backups.
- IO Rate: flat rate per 1 million IOPS.