{"id":25402,"date":"2018-11-07T08:30:29","date_gmt":"2018-11-07T16:30:29","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25402"},"modified":"2018-12-11T09:18:27","modified_gmt":"2018-12-11T17:18:27","slug":"announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/","title":{"rendered":"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database"},"content":{"rendered":"<p>We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/what-is-sql-server-machine-learning?view=sql-server-2017\">machine learning platform<\/a>. We are now bringing the same in-database machine learning capabilities to the fully managed Azure SQL Database. We are beginning with support for the R language in this preview release and will be adding Python language support in a future update.<\/p>\n<h2>End to end machine learning with R in Azure SQL Database<\/h2>\n<p>Using Machine Learning Services with R support in Azure SQL Database, you can \u2013<\/p>\n<ul>\n<li>Run R scripts to do data preparation and general purpose data processing \u2013 You can now bring your R scripts to Azure SQL Database where your data lives, instead of having to move data out to some other server to run R scripts. You eliminate the need for data movement and associated problems related to latency, security, compliance, etc.<\/li>\n<li>Train machine learning models in database \u2013 You can train models using open source algorithms or Microsoft&#8217;s scalable algorithms in RevoScaleR and MicrosoftML packages in database. You can easily scale your training to the entire dataset rather than relying on sample datasets pulled out of the database. During the model training and exploration stage, you can push your R scripts to run in database from any R IDE running on client machines using the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/tutorials\/deepdive-define-and-use-compute-contexts?view=sql-server-2017\">remote compute context<\/a> functionality in RevoScaleR package.<\/li>\n<li>Deploy your models and R scripts into production in stored procedures \u2013 The R scripts and trained models can be operationalized simply by embedding them in T-SQL stored procedures. Apps connecting to Azure SQL Database can benefit from predictions and intelligence in these models by just calling a stored procedure. You can also use the native T-SQL <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/predict-transact-sql?view=sql-server-2017\">PREDICT<\/a> function to operationalize models, which is already supported in Azure SQL Database for fast scoring in highly concurrent real-time scoring scenarios.<\/li>\n<\/ul>\n<p>These capabilities combined with the flexibility, scalability and elasticity benefits of the fully managed Azure SQL Database, make it a powerful AI environment on the cloud. The combination of capabilities like in-memory technology, columnstore indexes, and parallelized and scalable algorithms offer enterprise-grade performance for doing R based machine learning in Azure SQL Database.\u00a0 Integration of R in Azure SQL Database enables interesting hybrid scenarios as well \u2013 you can train a model in an on-premises SQL Server and use the model to score data in Azure SQL Database and vice versa.<\/p>\n<h2>Preview Functionality<\/h2>\n<p>During the preview, Microsoft will help upgrade\/migrate your existing databases or create new ones with R capability. This functionality is only supported in vCore-based purchasing models in Business Critical and General Purpose tiers. Existing databases should be <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-service-tiers-vcore#migration-from-dtu-model-to-vcore-model\">migrated<\/a> to the vCore based model before they can be enabled with R capability. \u00a0These databases can be migrated back out of the preview with no impact to your database. Only <a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/sql-database\/single\/\">Gen 5<\/a> hardware will support Machine Learning Services with R.<\/p>\n<p>This preview functionality is initially available in a limited number of regions in US, Asia Europe, and Australia with additional regions being added later. During the preview, Machine Learning Services with R is not supported for production usage.<\/p>\n<p>If you are interested in joining the preview program, please send an email to sqldbml@microsoft.com with these details: database name, logical server name, desired service tier, and subscription id. If you are creating a new database, we will only need the subscription id and the desired service tier. We will work with you to provide you with the new or migrated databases with R support. Depending on the demand, we may limit the access to this functionality during the preview. You do not need to do any additional installation or configuration steps after your database is enabled with R support.<\/p>\n<p>You can read more about Machine Learning Services with R in Azure SQL Database and try quick start tutorials at this <a href=\"https:\/\/aka.ms\/sqldbmldocs\">documentation page<\/a>. You can read about general <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/advanced-analytics\/what-is-sql-server-machine-learning?view=sql-server-2017\">Machine Learning Services in SQL Server.<\/a> We look forward to hearing from you at <a href=\"mailto:sqldbml@microsoft.com\">sqldbml@microsoft.com<\/a> and working closely with you on this preview!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing the same in-database machine learning capabilities to the fully managed Azure SQL Database.<\/p>\n","protected":false},"author":5562,"featured_media":25780,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[2391],"content-type":[2421],"topic":[],"coauthors":[2554],"class_list":["post-25402","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure-sql-database","content-type-announcements"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Announcing: Preview of Machine Learning Services with R support in Azure SQL Database - 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\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing the same in-database machine learning capabilities to the fully managed Azure SQL Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\" \/>\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=\"2018-11-07T16:30:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-11T17:18:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sumit Kumar\" \/>\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=\"Sumit Kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sumit-kumar\/\",\"@type\":\"Person\",\"@name\":\"Sumit Kumar\"}],\"headline\":\"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database\",\"datePublished\":\"2018-11-07T16:30:29+00:00\",\"dateModified\":\"2018-12-11T17:18:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\"},\"wordCount\":694,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\",\"name\":\"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png\",\"datePublished\":\"2018-11-07T16:30:29+00:00\",\"dateModified\":\"2018-12-11T17:18:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png\",\"width\":280,\"height\":180,\"caption\":\"a man standing next to a window\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database\"}]},{\"@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":"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database - 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\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database - Microsoft SQL Server Blog","og_description":"We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing the same in-database machine learning capabilities to the fully managed Azure SQL Database.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-11-07T16:30:29+00:00","article_modified_time":"2018-12-11T17:18:27+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png","type":"image\/png"}],"author":"Sumit Kumar","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Sumit Kumar","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sumit-kumar\/","@type":"Person","@name":"Sumit Kumar"}],"headline":"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database","datePublished":"2018-11-07T16:30:29+00:00","dateModified":"2018-12-11T17:18:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/"},"wordCount":694,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/","name":"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png","datePublished":"2018-11-07T16:30:29+00:00","dateModified":"2018-12-11T17:18:27+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/SQL-thumbnail3.png","width":280,"height":180,"caption":"a man standing next to a window"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/07\/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Announcing: Preview of Machine Learning Services with R support in Azure SQL Database"}]},{"@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\/25402","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\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=25402"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25402\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/25780"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=25402"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25402"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25402"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25402"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25402"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}