{"id":706,"date":"2020-06-18T09:00:56","date_gmt":"2020-06-18T09:00:56","guid":{"rendered":"https:\/\/www.sequallity.co.uk\/?p=706"},"modified":"2020-06-18T10:47:30","modified_gmt":"2020-06-18T10:47:30","slug":"beginners-guide-to-what-is-azure-sql-database","status":"publish","type":"post","link":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/","title":{"rendered":"Beginners Guide to What is Azure SQL Database?"},"content":{"rendered":"\n
\"Microsoft<\/figure><\/div>\n\n\n\n

OK, let’s try and breakdown the basic components of the cloud offering of Microsoft’s SQL Database and the various options available to you.<\/p>\n\n\n\n

Be aware there are two differing version of SQL Server (SQL Server Database Engine and Azure SQL Database) offered in the Azure cloud. Really?<\/p>\n\n\n\n

I Have Need of a Specific SQL Server Database Engine Feature<\/h2>\n\n\n\n

Well then, it might be best for you to visit this document. So le’ts say you’re a financial institution and by law you have to implement CDC (Change Data Capture), but if we have a look at the feature list…<\/p>\n\n\n\n

Microsoft Azure SQL Database Feature List<\/a><\/p>\n\n\n\n

\"Microsoft<\/figure><\/div>\n\n\n\n

Er, Single Databases are off the menu…so that first question could be, what features do we really need? Check the feature list, and what actually is acheivable.<\/p>\n\n\n\n

Please also be aware that this may change and indeed even this example maybe wrong at some point, check the situation right now.<\/p>\n\n\n\n

SQL Azure Database Deployment Models<\/h2>\n\n\n\n

There are only 3 basic models for Azure SQL Database and these being…<\/p>\n\n\n\n

  1. Single Database<\/li>
  2. Managed Instance<\/li>
  3. Elastic Pool<\/li><\/ol>\n\n\n\n

    It’s that easy. However, there are various flavours within each model. You can also deploy SQL Server Database Engine in an Azure VM called<\/p>\n\n\n\n

    1. SQL on a Virtual Machine<\/li><\/ol>\n\n\n\n

      So those are the four options you have. And we all love choice.<\/p>\n\n\n\n

      SQL Azure Database Deployment Models<\/h2>\n\n\n\n

      1. Single Database<\/h3>\n\n\n\n

      This really is great for if you only have one isolated database. When you create this single database you have to create a logical server and on that logical server you can add more databases onto a “database server”. This version of the database engine is Azure SQL Database.<\/p>\n\n\n\n

      2. Managed Instance<\/h3>\n\n\n\n

      This is great if you have many databases stacked on an on-premise physical tin or virtual box SQL Server and would like to move it to the cloud. Use this if you need the database features of the SQL Server Database Engine. Great for new applications but if you want to move an existing on-premise application remember that you are using all of the features of the most recent version of SQL Server.<\/p>\n\n\n\n

      3. Elastic Pool<\/h3>\n\n\n\n

      This is a collection of Single Databases from above. They all share the same resources, like CPU and memory. The Single Databases can be moved out of the Elastic Pool at any time. This is a great scenario for lower throughput servers with non-conficting use(r) times.<\/p>\n\n\n\n

      SQL Virtual Machine Deployment Model<\/h2>\n\n\n\n

      If you want full control over your OS level access then this is the solution you require. You can use a pay-as-you-go licence or easily use an existing licence. The biggest difference between a SQL VM and either SQL Database or Managed Instances is that the client can choose when to start patching. But the downside is you have to manage the virtual machine.<\/p>\n\n\n\n

      So here at Sequallity<\/em><\/strong><\/a>, we can run out SQL Server Health Check<\/em><\/strong><\/a> on either Azure SQL<\/em><\/strong><\/a>, SQL Server On-premises or Virtual or on Azure or on Managed Instances.<\/p>\n","protected":false},"excerpt":{"rendered":"

      OK, let’s try and breakdown the basic components of the cloud offering of Microsoft’s SQL Database and the various options available to you. Be aware there are two differing version of SQL Server (SQL Server Database Engine and Azure SQL Database) offered in the Azure cloud. Really? I Have Need of a Specific SQL Server Database Engine Feature Well then, it might be best for you to visit this document.<\/p>\n

      Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[843],"tags":[],"class_list":["post-706","post","type-post","status-publish","format-standard","hentry","category-azure-sql-for-beginners"],"yoast_head":"\nBeginners Guide to What is Azure SQL Database?<\/title>\n<meta name=\"description\" content=\"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Beginners Guide to What is Azure SQL Database?\" \/>\n<meta property=\"og:description\" content=\"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Consultancy and SQL Server Training\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-18T09:00:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-18T10:47:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2020\/01\/Azure-SQL-Database-Logo.jpg\" \/>\n<meta name=\"author\" content=\"John Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sequallity\" \/>\n<meta name=\"twitter:site\" content=\"@sequallity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\"},\"author\":{\"name\":\"John Parker\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\"},\"headline\":\"Beginners Guide to What is Azure SQL Database?\",\"datePublished\":\"2020-06-18T09:00:56+00:00\",\"dateModified\":\"2020-06-18T10:47:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\"},\"wordCount\":510,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"articleSection\":[\"Azure SQL for Beginners\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\",\"name\":\"Beginners Guide to What is Azure SQL Database?\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\"},\"datePublished\":\"2020-06-18T09:00:56+00:00\",\"dateModified\":\"2020-06-18T10:47:30+00:00\",\"description\":\"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure SQL for Beginners\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/azure-sql-for-beginners\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Beginners Guide to What is Azure SQL Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"name\":\"SQL Server Consultancy and SQL Server Training\",\"description\":\"where SQL and Quality join...\",\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\",\"name\":\"Sequallity Limited\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"contentUrl\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"width\":800,\"height\":229,\"caption\":\"Sequallity Limited\"},\"image\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\",\"https:\/\/twitter.com\/sequallity\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\",\"name\":\"John Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"caption\":\"John Parker\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Beginners Guide to What is Azure SQL Database?","description":"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.","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:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/","og_locale":"en_GB","og_type":"article","og_title":"Beginners Guide to What is Azure SQL Database?","og_description":"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.","og_url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/","og_site_name":"SQL Server Consultancy and SQL Server Training","article_publisher":"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","article_published_time":"2020-06-18T09:00:56+00:00","article_modified_time":"2020-06-18T10:47:30+00:00","og_image":[{"url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2020\/01\/Azure-SQL-Database-Logo.jpg"}],"author":"John Parker","twitter_card":"summary_large_image","twitter_creator":"@sequallity","twitter_site":"@sequallity","twitter_misc":{"Written by":"John Parker","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#article","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/"},"author":{"name":"John Parker","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f"},"headline":"Beginners Guide to What is Azure SQL Database?","datePublished":"2020-06-18T09:00:56+00:00","dateModified":"2020-06-18T10:47:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/"},"wordCount":510,"commentCount":0,"publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"articleSection":["Azure SQL for Beginners"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/","name":"Beginners Guide to What is Azure SQL Database?","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website"},"datePublished":"2020-06-18T09:00:56+00:00","dateModified":"2020-06-18T10:47:30+00:00","description":"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.","breadcrumb":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/beginners-guide-to-what-is-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/"},{"@type":"ListItem","position":2,"name":"Azure SQL for Beginners","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/azure-sql-for-beginners\/"},{"@type":"ListItem","position":3,"name":"Beginners Guide to What is Azure SQL Database?"}]},{"@type":"WebSite","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","name":"SQL Server Consultancy and SQL Server Training","description":"where SQL and Quality join...","publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization","name":"Sequallity Limited","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/","url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","contentUrl":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","width":800,"height":229,"caption":"Sequallity Limited"},"image":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","https:\/\/twitter.com\/sequallity"]},{"@type":"Person","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f","name":"John Parker","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","caption":"John Parker"}}]}},"_links":{"self":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/comments?post=706"}],"version-history":[{"count":5,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/706\/revisions"}],"predecessor-version":[{"id":1048,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/706\/revisions\/1048"}],"wp:attachment":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/media?parent=706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/categories?post=706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/tags?post=706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}