There are three options available to you when initializing a SQL Server instance in the Azure Cloud. The most recently announced option is the SQL Database Managed Instance, which was made publicly available at the start of Q3-2019 on the Azure Cloud.
What is a Managed Instance, and should you choose it over Single or Elastic Pool options in the Azure Cloud?
A SQL Managed Instance is a new service offering from Microsoft that provides almost full compatibility with the latest on-premise version of the SQL Server Database Engine.
Managed Instances are great for businesses looking to migrate their database to a fully-managed Platform as a Service (PaaS) environment in the Azure cloud. The Azure Data Migration Service (DMS) allows you to quickly initialize a highly-compatible cloud SQL database with native VNet support. Microsoft also has its Software Assurance program, where you can get a discounted rate on licensing fees by using the Azure Hybrid Cloud Benefit.
Since a Managed Instance is offered through the Azure Cloud, you get many Platform-as-a-Service (PaaS) benefits compared to on-premise SQL instances, including:
For business-critical and general workloads, Microsoft offers a 99.99% uptime service level agreement. In addition to this, they also have automated backup scheduling with configurable retention periods. These backups also allow you to go back to a specific date and time using Microsoft’s Point-in-time restore.
One of the most prominent features of Managed Instances is the new SQL Azure VNet compatibility. Instead of running on a public endpoint like Single and Elastic Pools, you get a private IP address on the Azure VNET, which you can connect to via your corporate VPN. This allows you to create tunneled connections from your office to your cloud network, offering transparent data encryption (TDE) and more security compared to Single or Elastic Pools.
Much like Single SQL instances, Managed Instances allow for quick and easy migration to the cloud.
The simplest way to migrate your database is through backing up your on-premise environment, and uploading it to a SQL Server Managed Instance via Azure Blob storage. From here, you can restore the backup on the cloud SQL Server instance and have a fully functioning replica of your on-premise deployment.
A Managed Instance of SQL Server in the cloud treats compute and storage components separately:
This offers a good balance between cost, reliability, and performance when using a SQL Server Managed Instance.
There are also options for faster storage with Managed Instances. If your SQL Database workloads require less than 1ms of storage latency, you may opt for an Ultra Disk. These disks can range from 4GB to 64TB in size and have a maximum throughput of 2000MB/s.
Trianz is a leading Microsoft Azure Managed Service Partner. We take pride in our human-first approach to IT consulting, offering 24/7 support on the Microsoft Azure Cloud via Concierto Cloud, an award-winning IP-based cloud management platform. Migrating to the cloud requires comprehensive planning and foresight, so consult with Trianz today and start your Azure migration journey.
Visit www.trianz.com/cloud to learn more about Azure, or get in contact today for a consultation using the form below!
Contact Us Today
Business intelligence (BI) refers to using software, services, and experts to translate data into actionable insights. Many businesses create and collect data daily and may have trouble processing it into meaningful information to drive strategic decisions. BI tools offer advantages to businesses because they can access and analyze data and create easy-to-read reports.Explore
Assessing What It Takes Digital transformation involves bringing digital apps to all areas of your business, bringing you more accuracy and efficiency in all that you do. In terms of digitally transforming a human resources (HR) department, this encompasses implementing new technology into current daily operations that can help the department succeed. It also requires a focus on people and process aspects.Explore
Digital disruption refers to the transformative change that occurs when new technologies revolutionize business processes, products, or services. It is a true hallmark of the modern age, as products and services that were once a thing of the imagination become a reality of daily life.Explore
The manufacturing industry is erupting in digital transformation, much like every other industry. Company decision-makers are seeing the benefits of digital transformation services, including: Sustainability Greater resource management Enhanced data collectionExplore
The Need for Master Data Management A clean, non-redundant, and consistent source of enterprise master data is key to improved decision making, increased agility against competition, and better relationships with stakeholders. High-quality master data truly is the backbone of execution in any business organization.Explore