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
What Is an SQL Query Engine? SQL query engine architecture was designed to allow users to query a variety of data sources within a single query. While early SQL-based query engines such as Apache Hive allowed analysts to cut through the clutter of analytical data, they found running SQL analytics on multi-petabyte data warehouses to be a time-intensive process that was difficult to visualize and hard to scale.Explore
A Winning Base for Successful Digital Transformations When it comes to developing a successful digital strategy, it is not just corporations planning to maximize the benefits of data assets and technology-focused initiatives. The Government of Western Australia recently unveiled four key priorities for digital reform in its new Digital Strategy for 2021-2025.Explore
Engage Your Workforce with a Modern Employee Intranet Solution The employee intranet has changed significantly since it was first introduced in the early 1990s. What started as HTML-based static portals have now evolved into intuitive communication tools complete with search engines, user profiles, blogs, event planners, and more. Today, many organizations are taking a second look at employee intranets to bridge gaps between teams, build company culture, centralize information, increase productivity, and improve workflow.Explore
Adopting emerging cloud technologies, consolidating resources, and improving processes is the key. “IT no longer just supports corporate operations as it traditionally has but is fully participating in business value delivery. Not only does this shift IT from a back-office role to the front of business, but it also changes the source of funding from an overhead expense that is maintained, monitored, and sometimes cut, to the thing that drives revenue,” said John-David Lovelock, research vice president at Gartner.Explore
Deliver Powerful Insights Instantaneously with Federated Queries - No Matter Where Your Data Resides The concept of federated queries isn’t new. Facebook PrestoDB popularized the idea of distributed structured query language (SQL) query engines in 2013. Over the years, AWS, Google, Microsoft, and many others in the industry have accelerated the adoption of a distributed query engine model within their products. For example, AWS developed Amazon Athena on top of the Presto code base, while Google’s BigQuery is based on Cloud SQL.Explore
What is Unstructured Data? Almost 80% of the data that enterprises and organizations collect is unstructured - data without a set record format or structure. Unstructured data includes data such as emails, web pages, PDFs, documents, customer feedback, in-app reviews, social media, video files, audio files, and images.Explore