{"id":363,"date":"2015-01-29T10:15:00","date_gmt":"2015-01-29T18:15:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/"},"modified":"2024-01-22T22:48:41","modified_gmt":"2024-01-23T06:48:41","slug":"azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/","title":{"rendered":"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power"},"content":{"rendered":"<p><em>By Tiffany Wissner, Sr. Director for Data Platform Marketing<\/em><\/p>\n<p>Today we are announcing general availability for the latest update to Azure SQL Database, introduction of new SQL Database security features, more automation for SQL Server in Azure Virtual Machines and SQL Server on G-Series VMs.\u00a0 Take a closer look at these exciting new improvements.<\/p>\n<p><b>1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/b><b>New update to Azure SQL Database Generally Available in Europe<\/b><\/p>\n<p>Generally available today in Europe, the <a href=\"http:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-preview-whats-new\/\">latest version of SQL Database<\/a> introduces near-complete SQL Server engine compatibility, greater support for larger databases, and expanded Premium performance. Internal tests on over 600 million rows of data show Premium query performance improvements of around 5x in the new preview relative to today\u2019s Premium SQL Database and up to 100x when applying the In-memory columnstore technology.\u00a0<\/p>\n<p>General availability will continue across United States regions on February 9, 2015 with rollout to most datacenters worldwide by March 1, 2015. General availability pricing will take effect for databases on V12 servers worldwide on April 1, 2015.<\/p>\n<p><i>\u201cAs a company committed to maintaining the highest innovation standards for our global clients, we\u2019re always eager to test the latest features,\u201c said John Schlesinger, Chief Enterprise Architect at Temenos. \u201cSo previewing the latest version of SQL Database was a no-brainer for us. After running both a benchmark and some close-of-business workloads, which are required by our regulated banking customers, we saw significant performance gains including a doubling of throughput for large blob operations, which are essential for our customer\u2019s reporting needs.\u201d\u00a0<\/i><\/p>\n<p><b>2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/b><b>New Security Features for Azure SQL Database<\/b><\/p>\n<p>Today also marks the introduction of a suite of security features coming to the latest version of SQL Database; Row-Level Security, Dynamic Data Masking, and Transparent Data Encryption. These security features will join the existing Auditing feature to help customers further protect their cloud data and help further meet corporate and industry compliance policies. Available in public preview today across all of the new service tiers, customers can implement <a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=522705\">Row-level Security<\/a> on databases to enable implementation of fine-grained access control over rows in a database table for greater control over which users can access which data.<\/p>\n<p>Coming soon, SQL Database will also preview Dynamic Data Masking which is a policy-based security feature that helps limit the exposure of data in a database by returning masked data to non-privileged users who run queries over designated database fields, like credit card numbers, without changing data on the database. Finally, we are excited to announce that Transparent Data Encryption is coming to SQL Database V12 databases for encryption at rest. As data security is at the top of mind for customers building new applications in the cloud, these new security features will be available the Basic, Standard and Premium service tiers.\u00a0<\/p>\n<p><b>3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/b><b>More simplified availability, setup, backup, and patching for SQL Server in an Azure VM<\/b><\/p>\n<p>SQL Server AlwaysOn technology provides both the high availability and disaster recovery capabilities needed for mission critical applications.\u00a0 One of the challenges is getting the HA environment setup, as it\u2019s not trivial.\u00a0 Now with new auto HA setup capabilities using the <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2015\/01\/29\/sql-server-alwayson-template-in-azure-portal-now-supports-existing-domains-and-is-much-faster.aspx?WT.mc_id=Blog_SQL_Announce_DI\">AlwaysOn Portal Template <\/a>added for SQL Server in Azure VMs, this really becomes a simpler task, freeing up your valuable time and resources to focus on other business priorities.\u00a0 This automated setup provides listener configuration and provisions AlwaysOn VM cluster to meet HA and DR requirements.\u00a0 This new capability applies for hybrid scenarios where you might be setting up failover for an on-premises SQL Server workload or a cloud only SQL Server workload when you want to setup failover from one Azure region to another.<\/p>\n<p>Backups for data security are easier now as well with the ability to <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/azure\/dn906091.aspx\">automate full SQL Server<\/a> backups from an Azure VM to Azure Storage.\u00a0 Additionally, SQL Server patches delivered through Windows Update also get better with <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2015\/01\/29\/automated-backup-and-automated-patching-for-sql-server-in-azure-portal-and-powershell.aspx?WT.mc_id=Blog_SQL_Announce_DI\">new auto patching capability<\/a> that gives you more granular control over the windows update scheduler for predictable timing of updates. Monitoring and managing SQL Server instances running in Azure VMs gets better as well with the ability to view and manage SQL Server alerts directly through the Azure Portal.<\/p>\n<p>The new suite of new capabilities along with <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2014\/06\/18\/why-sql-server-runs-best-on-microsoft-azure.aspx?linkId=8580063\">previously released Azure VM capabilities<\/a> \u00a0helps make running large enterprise SQL Server workloads in Azure VMs more efficient than ever before.<\/p>\n<p><b>4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/b><b>SQL Server on Massive G-Series VMs<\/b><\/p>\n<p>The new <a href=\"http:\/\/azure.microsoft.com\/blog\/2015\/01\/08\/azure-is-now-bigger-faster-more-open-and-more-secure\/\">G-Series VMs<\/a> are ideal for large SQL Server OLTP workloads, especially combined with SQL Server 2014 in-memory OLTP technology, as the new Azure G-Series VMs offer up to 32vCPUs, 448GB of memory, and 6.59TB of local SSD.\u00a0 Combine this with the in-memory OLTP technology built-in to SQL Server 2014, you can now maximize the performance of these large VMs by taking advantage of unique parallel processing in-memory architecture that removes database dead locks while ensuring 100% durability.\u00a0 This means not only can you get x factor transactional performance gains, but you can also gain x factor improvement in concurrency by taking full advantage of 32vCPUs.\u00a0<\/p>\n<p><b>Great options in Azure for your SQL Server enterprise workloads<\/b><\/p>\n<p>Whether you are looking to run your SQL Server workload in an Azure virtual machine or via the SQL Database managed service, there\u2019s no better time than now to move your enterprise workloads to the cloud or build new applications with Microsoft Azure.<\/p>\n<p>If you have an ecosystem of IT resources who can continue to manage and maintain your application in the cloud, SQL Server on an Azure Virtual Machine is the ideal option\u2014now with even more built-in productivity, power and scale. If you don\u2019t have an ecosystem of IT resources or don\u2019t want them maintaining and patching every database in your portfolio, the greater SQL Server compatibility, predictable Premium performance, built-in 99.99% availability and upcoming suite of security features make Azure SQL Database an ideal destination.<\/p>\n<p>We\u2019re excited to share these ongoing improvements of our SQL Server cloud offerings with you; helping make SQL Server on an Azure VM and Azure SQL Database two great migration or deployment targets for your enterprise-grade SQL Server workloads.<\/p>\n<p>If you haven\u2019t already, start a free trial on <a href=\"http:\/\/azure.microsoft.com\/en-us\/services\/virtual-machines\/sql-server\/\">SQL Server in Virtual Machines<\/a> or <a href=\"http:\/\/azure.microsoft.com\/en-us\/services\/sql-database\/\">Azure SQL Database<\/a> today!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Tiffany Wissner, Sr. Director for Data Platform Marketing Today we are announcing general availability for the latest update to Azure SQL Database, introduction of new SQL Database security features, more automation for SQL Server in Azure Virtual Machines and SQL Server on G-Series VMs.\u00a0 Take a closer look at these exciting new improvements. 1.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2391],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-363","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-sql-database","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"By Tiffany Wissner, Sr. Director for Data Platform Marketing Today we are announcing general availability for the latest update to Azure SQL Database, introduction of new SQL Database security features, more automation for SQL Server in Azure Virtual Machines and SQL Server on G-Series VMs.\u00a0 Take a closer look at these exciting new improvements. 1.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-29T18:15:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:48:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power\",\"datePublished\":\"2015-01-29T18:15:00+00:00\",\"dateModified\":\"2024-01-23T06:48:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\"},\"wordCount\":1032,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\",\"name\":\"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-01-29T18:15:00+00:00\",\"dateModified\":\"2024-01-23T06:48:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/","og_locale":"en_US","og_type":"article","og_title":"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power - Microsoft SQL Server Blog","og_description":"By Tiffany Wissner, Sr. Director for Data Platform Marketing Today we are announcing general availability for the latest update to Azure SQL Database, introduction of new SQL Database security features, more automation for SQL Server in Azure Virtual Machines and SQL Server on G-Series VMs.\u00a0 Take a closer look at these exciting new improvements. 1.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-01-29T18:15:00+00:00","article_modified_time":"2024-01-23T06:48:41+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power","datePublished":"2015-01-29T18:15:00+00:00","dateModified":"2024-01-23T06:48:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/"},"wordCount":1032,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/","name":"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-01-29T18:15:00+00:00","dateModified":"2024-01-23T06:48:41+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/01\/29\/azure-is-the-ideal-cloud-for-your-database-workloads-with-increased-sql-server-compatibility-security-automation-and-power\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Azure is the Ideal Cloud for Your Database Workloads with Increased SQL Server Compatibility, Security, Automation, and Power"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=363"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/363\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=363"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=363"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=363"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=363"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=363"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}