eBooks/eGuides

An-easier-path-to-the-cloud-for-your-legacy-SQL-Server-data

Issue link: https://insights.oneneck.com/i/1171388

Contents of this Issue

Navigation

Page 6 of 14

05 Azure SQL Database Managed Instance separates compute and storage components. You can select compute nodes with 8, 16, or 24 cores and Azure Premium Disk Storage. Azure SQL Database Managed Instance uses the same Azure SQL Database infrastructure that organizations have been using for billions of transactions daily. The only difference is that Azure SQL Database Managed Instance provides your organization with the entire SQL Server instance—instead of individual databases—while preserving PaaS capabilities. It's a fully-managed SQL Server instance in the Azure cloud, using the same SQL Server database engine, and it incorporates the latest features, performance improvements, and security patches. You'll need to create a virtual network, and then place your database in Azure SQL Database Managed Instance inside the virtual network. From there, it will work as a private SQL Server instance on Azure. All databases within that instance are positioned on the same SQL Server instance, which gives you consistent functionality like global temp tables, cross-database queries, SQL Server Agent, and so on. All other server-level objects, such as sign-ins or SQL Server Agent sign-ins, are appropriately replicated in the environment. Multiple managed instances are grouped in a virtual cluster that can be placed in a virtual network (VNet) and isolated from the public internet. These virtual clusters provide capabilities for cross-instance queries and Service Broker messaging. Chapter 04 How will it work for me? 04 How will it work for me? 05

Articles in this issue

Archives of this issue

view archives of eBooks/eGuides - An-easier-path-to-the-cloud-for-your-legacy-SQL-Server-data