{"id":17259,"date":"2021-09-17T16:15:00","date_gmt":"2021-09-17T10:45:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=17259"},"modified":"2021-09-17T16:19:14","modified_gmt":"2021-09-17T10:49:14","slug":"create-and-query-azure-sql-database","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/","title":{"rendered":"Introduction to Azure SQL Database For Beginners &#038; Steps to Deploy"},"content":{"rendered":"<p>There are very few relational database systems as established and widely used as Microsoft\u2019s SQL Server. SQL Server on Microsoft Azure comes in 3 different types (commonly known as the Azure SQL family):<\/p>\n<p>1. SQL Server on Azure VM (IaaS)<\/p>\n<p>2. Azure SQL Database (PaaS)<\/p>\n<p>3. Azure SQL Managed Instance (PaaS). The IaaS offering, SQL Server on Azure VM, is similar to an on-premises service where Microsoft manages the virtualization, hardware, and infrastructure, and DBAs manage every aspect of SQL Server.<\/p>\n<p>The PaaS offerings, Azure SQL Managed Instance, and Azure SQL DB allow DBAs to focus more on capacity planning, monitoring, and tuning, while Microsoft takes care of areas such as high availability, backup, and more. Azure SQL Database<\/p>\n<p>1. Azure SQL DB aims to minimize administration costs for using SQL Server.<\/p>\n<p>2. The OS, SQL Server instance, and most aspects of database administration\u2014such as backups, upgrades, and high availability\u2014are managed by Microsoft.<\/p>\n<p>3. You are only responsible for the data held in the database&#8230;&#8230;<\/p>\n<p>Azure SQL Database is recommended when:<\/p>\n<p>1. You are building new cloud-based applications.<\/p>\n<p>2. You are building applications using a scale-out pattern.<\/p>\n<p>3. You want to minimize administration and support costs.<\/p>\n<p>4. You do not have suitable IT resources to provide support and maintenance.<\/p>\n<p>5. You do not need full administrative control of the SQL Server.<\/p>\n<p>6. You want to work with databases &lt; 1 TB.<\/p>\n<p>For more info, check my blog: <a href=\"https:\/\/k21academy.com\/microsoft-azure\/database-administrator\/create-and-query-azure-sql-database\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30023_september2\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/dp30023<\/strong><\/em><\/a><\/p>\n<p>which covers:<\/p>\n<p>1. What Is a Database?<\/p>\n<p>2. History of Azure SQL<\/p>\n<p>3. Azure SQL Database<\/p>\n<p>4. Provisioning an Azure SQL Database<\/p>\n<p>If you are planning to become a Microsoft Azure Database Administrator Associate, then join the FREE CLASS now at\u00a0<a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_september21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/ dp30002<\/strong><\/em><\/a>\u00a0.<\/p>\n<p><a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_september21\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/06\/DBAdmin_CU.gif\" alt=\"DBAdmin_CU\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are very few relational database systems as established and widely used as Microsoft\u2019s SQL Server. SQL Server on Microsoft [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":17264,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[568,540],"tags":[],"class_list":["post-17259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dp-300","category-microsoft-azure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create Azure SQL Database &amp; Query the database<\/title>\n<meta name=\"description\" content=\"This blog post gives a walkthrough of the Step-By-Step hands-on create and Query Azure SQL Database using the Azure portal.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Azure SQL Database &amp; Query the database\" \/>\n<meta property=\"og:description\" content=\"This blog post gives a walkthrough of the Step-By-Step hands-on create and Query Azure SQL Database using the Azure portal.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-17T10:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-17T10:49:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png\" \/>\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\/png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/\",\"name\":\"Create Azure SQL Database & Query the database\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png\",\"datePublished\":\"2021-09-17T10:45:00+00:00\",\"dateModified\":\"2021-09-17T10:49:14+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"This blog post gives a walkthrough of the Step-By-Step hands-on create and Query Azure SQL Database using the Azure portal.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction to Azure SQL Database For Beginners &#038; Steps to Deploy\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Azure SQL Database & Query the database","description":"This blog post gives a walkthrough of the Step-By-Step hands-on create and Query Azure SQL Database using the Azure portal.","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:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"Create Azure SQL Database & Query the database","og_description":"This blog post gives a walkthrough of the Step-By-Step hands-on create and Query Azure SQL Database using the Azure portal.","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/","article_published_time":"2021-09-17T10:45:00+00:00","article_modified_time":"2021-09-17T10:49:14+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/","name":"Create Azure SQL Database & Query the database","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png","datePublished":"2021-09-17T10:45:00+00:00","dateModified":"2021-09-17T10:49:14+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"This blog post gives a walkthrough of the Step-By-Step hands-on create and Query Azure SQL Database using the Azure portal.","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/09\/CreateQuery_BlogImage.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/09\/17\/create-and-query-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Introduction to Azure SQL Database For Beginners &#038; Steps to Deploy"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/17259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=17259"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/17259\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/17264"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=17259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=17259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=17259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}