{"id":18056,"date":"2016-12-09T08:00:06","date_gmt":"2016-12-09T16:00:06","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=18056"},"modified":"2024-01-22T22:50:39","modified_gmt":"2024-01-23T06:50:39","slug":"sql-server-python-whats-new","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/","title":{"rendered":"SQL Server + Python \u2014 What\u2019s new"},"content":{"rendered":"<p>Python is one of the most popular and fastest-growing languages used today. <a href=\"https:\/\/mkleehammer.github.io\/pyodbc\/\">Pyodbc<\/a> (Python-SQL Server Connector) is an open source Python module maintained by <a href=\"https:\/\/github.com\/mkleehammer\">Michael Kleehammer<\/a> that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud. Pyodbc is also cross platform and can be installed using <a href=\"https:\/\/pypi.python.org\/pypi\/pyodbc\/3.1.1\">pip<\/a>.<\/p>\n<p>We recently announced <a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/11\/16\/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server\/\">SQL Server v.Next CTP1 on Linux and Windows<\/a>, which brings the power of SQL Server to both Windows and \u2014 for the first time ever \u2014 Linux. You can now connect your applications to SQL Server running on Linux, Windows and macOS (with Docker).<\/p>\n<p>For our Python developers, we have a few updates that will improve Python connectivity with SQL Server. Pyodbc is now:<\/p>\n<ul>\n<li><b>Officially supported:<\/b> You can contact Microsoft Customer Service and Support (CSS) via phone, email, Twitter, forums, etc., to report and get help with any issue.<\/li>\n<li><b>Available in Jupyter Notebooks for SQL Server: <\/b><a href=\"https:\/\/notebooks.azure.com\/\">The Jupyter Notebook<\/a> is a web application that allows you to create and share documents that contain live code, equations and visualizations.<b> <\/b>Pyodbc and its dependencies ship out of the box with Juypter notebooks on Azure. To get started, go to <a href=\"https:\/\/notebooks.azure.com\">notebooks.azure.com<\/a> and create a new Python 2 notebook. Check out the <a href=\"https:\/\/raw.githubusercontent.com\/Microsoft\/sql-server-samples\/master\/samples\/tutorials\/python\/jupyter\/sample_python_jupyter.py\">code sample<\/a> and paste it in your notebook\u2019s interactive prompt to get started.<\/li>\n<li><b>Compatible with <\/b><a href=\"https:\/\/pypi.python.org\/pypi\/pyodbc\/3.1.1\"><b>Python 3.5<\/b><\/a><b> and Django 1.10 through <\/b><a href=\"https:\/\/github.com\/michiya\/django-pyodbc-azure\"><b>Django-pyodbc-azure<\/b><\/a><b>. <\/b><\/li>\n<\/ul>\n<h4>Get started today<\/h4>\n<ul>\n<li>Try the new <a href=\"http:\/\/aka.ms\/sqldev?utm_medium=Referral&amp;utm_source=https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/12\/09\/sql-server-python-whats-new\/\">getting started tutorials<\/a> that show you how to:\n<ul>\n<li>Install SQL Server on Linux or Windows or run on Docker in multiple platforms.<\/li>\n<li>Create a simple app using C#, Java, Node.js, PHP and Python with SQL Server.<\/li>\n<li>Create a simple app using popular web frameworks like Django with SQL Server.<\/li>\n<li>Try out some cool SQL Server features that can make your apps shine.<\/li>\n<\/ul>\n<\/li>\n<li>Get the latest v17.0 RC1 versions of <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx\">SQL Server Management Studio (SSMS)<\/a> and <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt204009.aspx\">SQL Server Data Tools (SSDT)<\/a>.<\/li>\n<li><a href=\"https:\/\/aka.ms\/mssql-marketplace\">Get the <b>mssql<\/b> extension<\/a> for Visual Studio Code and develop apps with SQL Server on Linux\/macOS\/Windows.<\/li>\n<\/ul>\n<h4>Connect with us<\/h4>\n<p>Join the conversation at <a href=\"https:\/\/gitter.im\/mssqldev\/Lobby\">https:\/\/gitter.im\/mssqldev<\/a>.<\/p>\n<h4>Learn more<\/h4>\n<ul>\n<li>Visit <a href=\"https:\/\/channel9.msdn.com\/Events\/Connect\/2016\">Connect();<\/a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.<\/li>\n<\/ul>\n<h4>Learn more<\/h4>\n<ul>\n<li>Go to the <a href=\"http:\/\/www.sqlserveronlinux.com\/\">next release of SQL Server webpage<\/a> to get started with interactive SQL Server on Linux hands-on labs for <a href=\"https:\/\/aka.ms\/sqlserveronredhatlab4linuxadmins\">Linux administrators new to SQL Server<\/a> and for <a href=\"https:\/\/aka.ms\/sqlserveronredhatlab4sqladmins\">existing SQL Server database administrators new to Linux<\/a>.<\/li>\n<li>Visit <a href=\"https:\/\/connectevent.microsoft.com\/\">Connect();<\/a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.<\/li>\n<\/ul>\n<h4>Other videos in this series<\/h4>\n<ul>\n<li>Watch the <a href=\"https:\/\/www.youtube.com\/watch?v=oEpJB87Xg9U&amp;feature=youtu.be\">Microsoft Mechanics video<\/a> to see how to get started with SQL Server on Linux in less than a minute.<\/li>\n<li><a href=\"https:\/\/channel9.msdn.com\/Events\/Connect\/2016\/173\/\">SQL Server on Linux: use SQL Tools with SQL Server<\/a><\/li>\n<li><a href=\"https:\/\/channel9.msdn.com\/events\/connect\/2016\/160\">SQL Server + Node.js: what\u2019s new<\/a><\/li>\n<li><a href=\"https:\/\/channel9.msdn.com\/events\/connect\/2016\/152\">SQL Server + Java: what\u2019s new<\/a><\/li>\n<li><a href=\"https:\/\/channel9.msdn.com\/events\/connect\/2016\/151\">SQL Server + C#: what\u2019s new<\/a><\/li>\n<li><a href=\"https:\/\/channel9.msdn.com\/Events\/Connect\/2016\/182\">SQL Server + PHP: what\u2019s new<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud.<\/p>\n","protected":false},"author":1457,"featured_media":36432,"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":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-18056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1593580419-556","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-5-1593580452-31","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server + Python \u2014 What\u2019s new - 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\/2016\/12\/09\/sql-server-python-whats-new\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server + Python \u2014 What\u2019s new - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/\" \/>\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=\"2016-12-09T16:00:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"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\/2016\/12\/09\/sql-server-python-whats-new\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server + Python \u2014 What\u2019s new\",\"datePublished\":\"2016-12-09T16:00:06+00:00\",\"dateModified\":\"2024-01-23T06:50:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/\"},\"wordCount\":497,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/\",\"name\":\"SQL Server + Python \u2014 What\u2019s new - 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\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg\",\"datePublished\":\"2016-12-09T16:00:06+00:00\",\"dateModified\":\"2024-01-23T06:50:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg\",\"width\":1280,\"height\":720,\"caption\":\"graphical user interface, text\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server + Python \u2014 What\u2019s new\"}]},{\"@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":"SQL Server + Python \u2014 What\u2019s new - 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\/2016\/12\/09\/sql-server-python-whats-new\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server + Python \u2014 What\u2019s new - Microsoft SQL Server Blog","og_description":"Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-12-09T16:00:06+00:00","article_modified_time":"2024-01-23T06:50:39+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg","type":"image\/jpeg"}],"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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server + Python \u2014 What\u2019s new","datePublished":"2016-12-09T16:00:06+00:00","dateModified":"2024-01-23T06:50:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/"},"wordCount":497,"commentCount":2,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/","name":"SQL Server + Python \u2014 What\u2019s new - 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\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg","datePublished":"2016-12-09T16:00:06+00:00","dateModified":"2024-01-23T06:50:39+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2021\/09\/sql-server-python-whats-new.jpg","width":1280,"height":720,"caption":"graphical user interface, text"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/12\/09\/sql-server-python-whats-new\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server + Python \u2014 What\u2019s new"}]},{"@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\/18056","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=18056"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/18056\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/36432"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=18056"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=18056"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=18056"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=18056"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=18056"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=18056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}