{"id":28086,"date":"2019-09-03T11:00:49","date_gmt":"2019-09-03T18:00:49","guid":{"rendered":""},"modified":"2024-01-08T22:48:17","modified_gmt":"2024-01-09T06:48:17","slug":"visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/","title":{"rendered":"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters"},"content":{"rendered":"<p>Today we\u2019re announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs after data scientist\u2019s data explore and experimentation. The Visual Studio Code Apache Spark and Hive extension enables you to enjoy cross platform and enhanced light weight Python editing capabilities. It covers scenarios around Python authoring, debugging, Jupyter Notebook integration, and notebook like interactive query.<\/p>\n<p>With the Visual Studio Code extension, you can enjoy native Python programming experiences such as linting, debugging support, language service, and so on. You can <strong>run current line<\/strong>, <strong>run selected lines of code,<\/strong> or <strong>run all<\/strong> for your PY file. You can import and export a .ipynb notebook and perform a notebook like query including <em>Run Cell, Run Above, or Run Below<\/em><strong>.<\/strong> You can also enjoy a notebook like interactive experience that includes your source code and markdown comments along with the running results and output. You can remove the unneeded sections, enter comments, or type additional code in the interactive results window. Moreover, you can visualize your results in a graphic format through a matplotlib like Jupyter Notebook. The <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/big-data-cluster\/spark-hive-tools-vscode?view=sqlallproducts-allversions\">integration with SQL Server 2019 Big Data Clusters<\/a> empowers you to quickly submit a PySpark batch job to the big data cluster and monitor job progress.<\/p>\n<h2>Highlights of key features<\/h2>\n<ul>\n<li>You can link to SQL Server: The toolkit enables you to <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/big-data-cluster\/spark-hive-tools-vscode?view=sqlallproducts-allversions#link-a-sql-server-big-data-cluster\">connect<\/a> and submit PySpark jobs to <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/introducing-microsoft-sql-server-2019-big-data-clusters\/\">SQL Server 2019 Big Data Clusters<\/a>.<\/li>\n<li>Python editing: Develop PySpark applications with native Python authoring support (e.g. IntelliSense, auto format, error checking, etc.).<\/li>\n<li>Jupyter Notebook integration: Import and export .ipynb files.<\/li>\n<li>PySpark interactive: Run selected lines of code, or notebook like cell PySpark execution, and interactive visualizations.<\/li>\n<li>PySpark batch: Submit PySpark applications to SQL Server 2019 Big Data Clusters.<\/li>\n<li>PySpark monitoring: Integrate with the Apache Spark history server to view job history, debug, and diagnose Spark jobs.<\/li>\n<\/ul>\n<h2>How to install or update<\/h2>\n<p>First, install Visual Studio Code and download Mono 4.2.x for Linux or Mac. Then get the latest Apache Spark and Hive tools by going to the Visual Studio Code extension repository or the Visual Studio Code Marketplace and searching for <strong>Spark.<\/strong><\/p>\n<p>For more information about Apache Spark \u00a0and Hive tools for Visual Studio Code, please use the following resources:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/big-data-cluster\/spark-hive-tools-vscode?view=sqlallproducts-allversions\">Visual Studio Code extension for SQL Server 2019 Big Data Clusters<\/a><\/li>\n<li><a href=\"https:\/\/code.visualstudio.com\/docs\/languages\/python#_jupyter-notebooks\">Python in Visual Studio Code<\/a><\/li>\n<\/ul>\n<p>If you have questions, feedback, comments, or bug reports, please use the comments below or send a note to <a href=\"mailto:hdivstool@microsoft.com\">hdivstool@microsoft.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we\u2019re announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs after data scientist\u2019s data explore and experimentation.<\/p>\n","protected":false},"author":5562,"featured_media":27339,"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":[5227,2536],"content-type":[2421,2448],"topic":[2451,2466],"coauthors":[2605],"class_list":["post-28086","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-sql","product-sql-server-2019","content-type-announcements","content-type-updates","topic-big-data","topic-developer","review-flag-2-1593580436-981","review-flag-4-1593580446-456","review-flag-integ-1593580287-179"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - 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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Today we\u2019re announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs after data scientist\u2019s data explore and experimentation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\" \/>\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=\"2019-09-03T18:00:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-09T06:48:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.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=\"Jenny Jiang\" \/>\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=\"Jenny Jiang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/jenny-jiang\/\",\"@type\":\"Person\",\"@name\":\"Jenny Jiang\"}],\"headline\":\"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters\",\"datePublished\":\"2019-09-03T18:00:49+00:00\",\"dateModified\":\"2024-01-09T06:48:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\"},\"wordCount\":438,\"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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\",\"name\":\"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - 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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png\",\"datePublished\":\"2019-09-03T18:00:49+00:00\",\"dateModified\":\"2024-01-09T06:48:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png\",\"width\":280,\"height\":180,\"caption\":\"a woman sitting at a table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters\"}]},{\"@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":"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - 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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/","og_locale":"en_US","og_type":"article","og_title":"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - Microsoft SQL Server Blog","og_description":"Today we\u2019re announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs after data scientist\u2019s data explore and experimentation.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2019-09-03T18:00:49+00:00","article_modified_time":"2024-01-09T06:48:17+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png","type":"image\/png"}],"author":"Jenny Jiang","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Jenny Jiang","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/jenny-jiang\/","@type":"Person","@name":"Jenny Jiang"}],"headline":"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters","datePublished":"2019-09-03T18:00:49+00:00","dateModified":"2024-01-09T06:48:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/"},"wordCount":438,"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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/","name":"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - 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\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png","datePublished":"2019-09-03T18:00:49+00:00","dateModified":"2024-01-09T06:48:17+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/05\/SQL-Server-blog.png","width":280,"height":180,"caption":"a woman sitting at a table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/03\/visual-studio-code-develop-pyspark-jobs-for-sql-server-2019-big-data-clusters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters"}]},{"@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\/28086","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=28086"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/28086\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/27339"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=28086"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=28086"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=28086"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=28086"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=28086"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=28086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}