{"id":29364,"date":"2019-12-11T09:00:48","date_gmt":"2019-12-11T17:00:48","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=29364"},"modified":"2024-01-08T22:43:52","modified_gmt":"2024-01-09T06:43:52","slug":"tools-and-commands-for-running-sql-server-2019-on-linux","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/","title":{"rendered":"Tools and commands for running SQL Server 2019 on Linux"},"content":{"rendered":"<p>Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it\u2019s the same SQL Server database code, and includes even more of the same features and services as the Windows release. This introductory blog post about running Microsoft SQL Server 2019 on Linux provides basic information database professionals need to know before upgrading or migrating SQL Server onto Linux.<\/p>\n<h2>Supported Linux platforms<\/h2>\n<p>Microsoft SQL Server 2019 is tested and supported to run on several Linux distribution platforms:<\/p>\n<ul>\n<li>Red Hat Enterprise Linux (RHEL)<\/li>\n<li>SUSE Linux Enterprise Server (SLES)<\/li>\n<li>Ubuntu<\/li>\n<\/ul>\n<p>Along with the above versions of Linux distributions, SQL Server 2019 is supported in a container scenario using a Docker image.\u00a0 Running a SQL Server database inside a Docker engine with Linux offers more flexibility, faster recovery, and quicker deployments, including deployments into the Azure cloud. For those becoming familiar with Linux, Docker for Windows or Mac gives you the option to run a Docker engine on your workstation with SQL Server 2019 on Linux.<\/p>\n<p>Along with Docker technology, orchestration can be achieved, both managing and deploying SQL Server containers on Linux using Red Hat Open shift or Kubernetes. This includes SQL Server 2019 Big Data Clusters (BDC), fully scalable clusters with SQL Server, Spark, and Hadoop File System (HDFS). BDCs provide the ability to read, write, and analyze big data with T-SQL or Spark, and you can combine big data and relational data, too.<\/p>\n<p>While this post has focused on RHEL, SLES, Ubuntu, and container options for Linux, you may have questions regarding other Linux distributions that may be able to run SQL Server 2019, but they\u2019re not supported by Microsoft. Always consider the database server\u2019s use before deciding to run SQL Server 2019 on an unsupported operating system and refer to Microsoft\u2019s<u><a href=\"https:\/\/support.microsoft.com\/help\/4047326\/support-policy-for-microsoft-sql-server\"> support policy on the topic<\/a>.<\/u><\/p>\n<h2>Tools for Microsoft SQL Server 2019 running on Linux<\/h2>\n<p>With the release of SQL Server 2019, there are more tools that database professionals can use with SQL Server 2019 running on Linux:<\/p>\n<ul>\n<li>Windows-based tools\u2014You can use any existing tools that run on Windows to access SQL Server on Linux. This includes SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), operational support systems, and third-party tools.<\/li>\n<li>Activity Monitor\u2014Use SSMS on Windows to connect remotely and use tools\/features such as Activity Monitor commands on a Linux host.<\/li>\n<li>Azure Data Studio\u2014Use this cross-platform database tool to manage the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux. That includes SQL Server 2019 running on Linux. You can also create SQL Server Notebooks in Azure Data Studio, multiple team members to collaborate on projects.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/system-dynamic-management-views\/system-dynamic-management-views?view=sql-server-ver15\"><u>Dynamic Management Views (DMVs)<\/u><\/a>\u2014System DMVs collect different types of information about SQL Server, including Linux process information. Use server state information in conjunction with dynamic management functions (DMFs) to monitor the health of a server instance, diagnose problems, and tune performance.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/performance\/monitoring-performance-by-using-the-query-store?view=sql-server-ver15]\"><u>Query Store<\/u><\/a>\u2014Use Query Store for insights on query plan choice and performance. It simplifies performance troubleshooting by helping database professionals quickly find performance differences caused by query plan changes.<\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/sql_server_team\/new-in-ssms-performance-dashboard-built-in\/\"><u>Performance Dashboard<\/u><\/a>\u2014The Performance Dashboard helps you determine if there\u2019s a performance bottleneck on the connected SQL Server instance and provides diagnostic data to help you resolve the problem.<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/linux\/sql-server-linux-configure-mssql-conf?view=sql-server-ver15]--mssql-conf\"><u>mssql-conf<\/u><\/a> is a configuration script that installs with SQL Server 2019 for Linux.<\/li>\n<\/ul>\n<h2>Command Line Tools for Microsoft SQL Server 2019 on Linux<\/h2>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/linux\/sql-server-linux-setup-tools?view=sql-server-ver15\"><u>sqlcmd<\/u><\/a> and Bulk Copy Protocol (BCP)\u2014These command-line tools are natively available on Linux. sqlcmd is a command-line query utility, and BCP is a bulk import-export utility.<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/mssql-scripter\"><u>mssql-scripter<\/u><\/a>\u2014This command-line tool on Linux generates T-SQL scripts for a SQL database running anywhere.<\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/\"><u>mssql-cli<\/u><\/a>\u2014This new, interactive command-line tool written in Python offers several enhancements over sqlcmd in the Terminal environment.<\/li>\n<\/ul>\n<p>With these tools and command line tools, you\u2019re now ready to run Microsoft SQL Server 2019 on Linux. To learn more about what you can do with Microsoft SQL Server 2019, check out the free Packt guide <a href=\"https:\/\/info.microsoft.com\/ww-landing-introducing-sql-server-2019-content.html\">Introducing Microsoft SQL 19<\/a>. If you\u2019re ready to jump to a fully managed cloud solution, check out the <a href=\"https:\/\/azure.microsoft.com\/en-us\/resources\/essential-guide-to-data-in-the-cloud\/\">Essential Guide to Data in the Cloud<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it\u2019s the same SQL Server database code, and includes even more of the same features and services as the Windows release. This introductory<\/p>\n","protected":false},"author":5562,"featured_media":29454,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2536,2418],"content-type":[2424],"topic":[],"coauthors":[2602],"class_list":["post-29364","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-sql","product-sql-server-2019","product-sql-server-on-linux","content-type-best-practices"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tools and commands for running SQL Server 2019 on Linux - 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\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tools and commands for running SQL Server 2019 on Linux - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it\u2019s the same SQL Server database code, and includes even more of the same features and services as the Windows release. This introductory\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\" \/>\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-12-11T17:00:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-09T06:43:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.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=\"Kellyn Gorman\" \/>\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=\"Kellyn Gorman\" \/>\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\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/kellyn-gorman\/\",\"@type\":\"Person\",\"@name\":\"Kellyn Gorman\"}],\"headline\":\"Tools and commands for running SQL Server 2019 on Linux\",\"datePublished\":\"2019-12-11T17:00:48+00:00\",\"dateModified\":\"2024-01-09T06:43:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\"},\"wordCount\":703,\"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\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\",\"name\":\"Tools and commands for running SQL Server 2019 on Linux - 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\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png\",\"datePublished\":\"2019-12-11T17:00:48+00:00\",\"dateModified\":\"2024-01-09T06:43:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png\",\"width\":280,\"height\":180,\"caption\":\"a person sitting at a table using a laptop\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tools and commands for running SQL Server 2019 on Linux\"}]},{\"@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":"Tools and commands for running SQL Server 2019 on Linux - 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\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/","og_locale":"en_US","og_type":"article","og_title":"Tools and commands for running SQL Server 2019 on Linux - Microsoft SQL Server Blog","og_description":"Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it\u2019s the same SQL Server database code, and includes even more of the same features and services as the Windows release. This introductory","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2019-12-11T17:00:48+00:00","article_modified_time":"2024-01-09T06:43:52+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png","type":"image\/png"}],"author":"Kellyn Gorman","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Kellyn Gorman","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/kellyn-gorman\/","@type":"Person","@name":"Kellyn Gorman"}],"headline":"Tools and commands for running SQL Server 2019 on Linux","datePublished":"2019-12-11T17:00:48+00:00","dateModified":"2024-01-09T06:43:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/"},"wordCount":703,"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\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/","name":"Tools and commands for running SQL Server 2019 on Linux - 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\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png","datePublished":"2019-12-11T17:00:48+00:00","dateModified":"2024-01-09T06:43:52+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/12\/thumbnail-1.png","width":280,"height":180,"caption":"a person sitting at a table using a laptop"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/12\/11\/tools-and-commands-for-running-sql-server-2019-on-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Tools and commands for running SQL Server 2019 on Linux"}]},{"@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"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/29364"}],"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=29364"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/29364\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/29454"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=29364"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=29364"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=29364"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=29364"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=29364"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=29364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}