{"id":23837,"date":"2023-02-27T07:48:00","date_gmt":"2023-02-27T06:48:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=23837"},"modified":"2023-03-24T09:47:42","modified_gmt":"2023-03-24T08:47:42","slug":"azure-sql-services-main-options","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/","title":{"rendered":"Azure SQL Services main options: a concise deployment guide"},"content":{"rendered":"\n<p>This article is a concise deployment guide with the main Azure SQL Services options. Azure SQL Services offer a suite of scalable, and flexible database solutions, designed to meet the needs of modern businesses. In this tutorial, we will explore the four available deployment options and their benefits.<\/p>\n\n\n\n<p>However Microsoft Azure offers three main options for <strong>Azure SQL Services<\/strong> :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>SQL Server on Azure Virtual Machines<\/strong> (VMs) and is IaaS type<\/li>\n\n\n\n<li><strong>Azure SQL Managed Instance<\/strong> of PaaS type<\/li>\n\n\n\n<li>and <strong>Azure SQL Database<\/strong> also PaaS type<\/li>\n<\/ol>\n\n\n\n<p>The fourth option is dedicated to IoT and is called <strong>Azure SQL Edge<\/strong>. Learn about the key features, use cases, and benefits of each option. This guide can help you make an informed decision when choosing the best solution for your organization.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"670\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/azure-SQL-services-options-comparison-1.jpg\" alt=\"Azure SQL Services comparison of the three main deployment options\" class=\"wp-image-23849\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/azure-SQL-services-options-comparison-1.jpg 840w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/azure-SQL-services-options-comparison-1-300x239.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/azure-SQL-services-options-comparison-1-768x613.jpg 768w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Azure SQL Services comparison of the three main deployment options<\/em><\/strong> (source: microsoft.com)<\/figcaption><\/figure><\/div>\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#1-sql-server-on-azure-virtual-machines-vms\" >1. SQL Server on Azure Virtual Machines (VMs)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#2-azure-sql-managed-instance\" >2. Azure SQL Managed Instance<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#3-azure-sql-database\" >3. Azure SQL Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#4-azure-sql-edge-is-designed-for-iot\" >4. Azure SQL Edge is designed for IoT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#conclusion-on-azure-sql-services-main-deployment-options\" >Conclusion on Azure SQL Services main deployment options<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-sql-server-on-azure-virtual-machines-vms\"><span class=\"ez-toc-section\" id=\"1-sql-server-on-azure-virtual-machines-vms\"><\/span>1. SQL Server on Azure Virtual Machines (VMs)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Azure SQL Server on VMs is an <strong>IaaS solution<\/strong> designed to run SQL Server on a virtual machine. So the VM is hosted in the Azure cloud. This option is ideal for organizations seeking a seamless <em>lift and shift<\/em> migration of their existing on-premises SQL Server installations. With this solution, you maintain full control over server and database configurations. Hence making it suitable for hybrid deployments and applications that require access to specific operating system features.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><em>Key Benefits for SQL Server on Azure VMs option for SQL Services<\/em><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Easily migrate existing SQL Server installations without major changes.<\/li>\n\n\n\n<li>Retain full control over server and database configurations.<\/li>\n\n\n\n<li>Perfect for hybrid deployments and applications requiring OS-level features.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-azure-sql-managed-instance\"><\/span>2. Azure SQL Managed Instance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The option called Azure SQL Managed Instance is a Platform-as-a-Service, i.e. a <strong>PaaS solution<\/strong> that offers near-100% compatibility with on-premises SQL Server instances while abstracting the underlying hardware and operating system. This service simplifies database management by automating software updates, backups, and other maintenance tasks, thereby reducing the administrative burden associated with supporting a database server instance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><em>Key Benefits for Azure SQL Managed instances for SQL Services<\/em><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Near-100% compatibility with on-premises SQL Server instances.<\/li>\n\n\n\n<li>Simplified database management with automated updates, backups, and maintenance tasks.<\/li>\n\n\n\n<li>Ideal for most cloud migration scenarios with minimal changes to existing applications.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-azure-sql-database\"><\/span>3. Azure SQL Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Azure SQL Database is a fully managed, highly scalable <strong>PaaS database<\/strong> service designed specifically for cloud applications. This service supports most core database-level capabilities of on-premises SQL Server, making it a suitable option for creating new applications in the cloud or migrating applications with minimal instance-level dependencies. It is available in two configurations: <em>Single Database<\/em> and <em>Elastic Pool<\/em>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Azure SQL Database single database configuration<\/h4>\n\n\n\n<p><strong><em>Single Database<\/em><\/strong> is designed for setting up and running a single SQL Server database in the cloud. Microsoft manages the server, and you only need to configure the database, create tables, and populate them with data. The database can be scaled to accommodate more storage space, memory, or processing power as needed. You can also opt for a serverless configuration where resources are automatically scaled and allocated as required.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Azure SQL Database Elastic Pool, configuration<\/h4>\n\n\n\n<p><strong><em>Elastic Pool<\/em><\/strong>, on the other hand, enables multiple databases to share resources such as memory, data storage, and processing power through a pool. This model is useful for databases with varying resource requirements, helping to reduce costs and optimize resource usage. Elastic Pool allows you to efficiently allocate and release resources as needed.<\/p>\n\n\n\n<p>Azure SQL Database is commonly used for modern cloud applications, systems with variable loads, and applications requiring high availability. It provides several business benefits, such as automatic updates and patches, scalability, high availability guarantees, and advanced threat protection. Additionally, Azure SQL Database offers auditing and encryption features to secure your data and help maintain regulatory compliance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><em>Key Benefits for Azure SQL Database<\/em><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fully managed and highly <a href=\"https:\/\/www.redhat.com\/en\/topics\/cloud-computing\/what-is-paas\" target=\"_blank\" rel=\"noreferrer noopener\">scalable PaaS<\/a> database service.<\/li>\n\n\n\n<li>Supports most core database-level capabilities of SQL Server.<\/li>\n\n\n\n<li>Ideal for new cloud solutions or migrating applications with minimal dependencies.<\/li>\n<\/ul>\n\n\n\n<p>A good and maybe mandatory way to get started on Azure is to <a href=\"https:\/\/expert-only.com\/en\/azure\/how-to-create-an-azure-account\/\">create a 12 months trial Azure account<\/a> and try the available options offered.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"pSEM9eSokH\"><a href=\"https:\/\/expert-only.com\/en\/azure\/how-to-create-an-azure-account\/\">How to create a 12 months trial Azure Account ?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to create a 12 months trial Azure Account ?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/azure\/how-to-create-an-azure-account\/embed\/#?secret=K5milW6C7r#?secret=pSEM9eSokH\" data-secret=\"pSEM9eSokH\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-azure-sql-edge-is-designed-for-iot\"><\/span>4. Azure SQL Edge is designed for IoT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Azure SQL Edge is a lightweight SQL engine optimized for Internet of Things (IoT) scenarios, designed to work efficiently with streaming time-series data. This solution enables data processing, analytics, and storage at the edge, allowing IoT devices to perform real-time analysis and minimize latency. By integrating seamlessly with other Azure services and tools, Azure SQL Edge empowers organizations to make data-driven decisions, improve operational efficiency, and harness the full potential of IoT data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-on-azure-sql-services-main-deployment-options\"><\/span>Conclusion on Azure SQL Services main deployment options<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Azure SQL Services offer three powerful and flexible database solutions to cater to various business needs. SQL Server on Azure VMs is best suited for &#8220;lift and shift&#8221; migrations and applications requiring OS-level features, while Azure SQL Managed Instance is perfect for cloud migration scenarios with minimal changes.<\/p>\n\n\n\n<p>Azure SQL Database, on the other hand, is the go-to choice for new cloud applications or migrating applications with minimal dependencies. And Azure SQL Edge is made specifically for IoT scenarios. By understanding the key features, use cases, and benefits of each option, you can make the right decision for your organization&#8217;s database requirements.<\/p>\n\n\n\n<p>One of the key benefits of SQL Server on Azure is that it can be combined with the other tools and applications like Python. For example to <a href=\"https:\/\/expert-only.com\/en\/python\/import-excel-into-sql-server-with-python\/\">automate Excel data import into a database<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/en\/python\/import-excel-into-sql-server-with-python\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>This article is a concise deployment guide with the main Azure SQL Services options. Azure SQL Services offer a suite of scalable, and flexible database solutions, designed to meet the needs of modern businesses. In this tutorial, we will <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\" title=\"Azure SQL Services main options: a concise deployment guide\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6274,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[667],"tags":[],"class_list":{"0":"post-23837","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-azure"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Azure SQL Services main options: a concise deployment guide<\/title>\n<meta name=\"description\" content=\"Guide with Azure SQL Services main options: SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database and Azure SQL Edge.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure SQL Services main options: a concise deployment guide\" \/>\n<meta property=\"og:description\" content=\"Guide with Azure SQL Services main options: SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database and Azure SQL Edge.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-27T06:48:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-24T08:47:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Azure SQL Services main options: a concise deployment guide\",\"datePublished\":\"2023-02-27T06:48:00+00:00\",\"dateModified\":\"2023-03-24T08:47:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\"},\"wordCount\":916,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg\",\"articleSection\":[\"Azure\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\",\"url\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\",\"name\":\"Azure SQL Services main options: a concise deployment guide\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg\",\"datePublished\":\"2023-02-27T06:48:00+00:00\",\"dateModified\":\"2023-03-24T08:47:42+00:00\",\"description\":\"Guide with Azure SQL Services main options: SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database and Azure SQL Edge.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure SQL Services main options: a concise deployment guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Azure SQL Services main options: a concise deployment guide","description":"Guide with Azure SQL Services main options: SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database and Azure SQL Edge.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/","og_locale":"en_US","og_type":"article","og_title":"Azure SQL Services main options: a concise deployment guide","og_description":"Guide with Azure SQL Services main options: SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database and Azure SQL Edge.","og_url":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-02-27T06:48:00+00:00","article_modified_time":"2023-03-24T08:47:42+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Azure SQL Services main options: a concise deployment guide","datePublished":"2023-02-27T06:48:00+00:00","dateModified":"2023-03-24T08:47:42+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/"},"wordCount":916,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg","articleSection":["Azure"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/","url":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/","name":"Azure SQL Services main options: a concise deployment guide","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg","datePublished":"2023-02-27T06:48:00+00:00","dateModified":"2023-03-24T08:47:42+00:00","description":"Guide with Azure SQL Services main options: SQL Server on Azure VMs, Azure SQL Managed Instance, Azure SQL Database and Azure SQL Edge.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/city-4F3310F581A_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/azure\/azure-sql-services-main-options\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Azure SQL Services main options: a concise deployment guide"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/23837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=23837"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/23837\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/6274"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=23837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=23837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=23837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}