datasheet: Microsoft SQL Server Managed Instance Datasheet
DB Best has performed Azure Readiness Assessments for organizations across the spectrum. Platform-as-a-Service (PaaS) offerings are very appealing to businesses of all sizes because it adds scalability and high availability while reducing administrative complexity. Most environments had databases from various versions of SQL Server (some of them really old) and needed modernization efforts to allow the business to realize true value of the information within. Azure SQL DB and elastic pools have been a PaaS offering in Azure for quite some time and many databases have been successfully migrated. However, many more databases were not able to migrate due to “blocking issues”.
With the release of Azure SQL Managed Instance, many of the blockers of transitioning a database (or set of databases) to a PaaS offering have been eliminated. Microsoft has also been committed to compatibility with older versions of SQL Server – back to SQL Server 2008 which also alleviates the need to worry about upgrading the database to a specific version. Since compatibility is a database level setting, a single MI can service 100 databases with various compatibility levels. High Availability is built-in to the service and Disaster Recovery is essentially a checkbox setting.
Azure SQL Managed Instance provides the Scalability, High Availability, and Flexibility of a PaaS offering while reducing administrative complexity. It is the missing piece to help customers truly take advantage of the PaaS offerings and virtually eliminate any need for on-premises database servers.
Check out our offer datasheet for more information on how you can optimize your SQL Server landscape on Azure with Managed Instances.