{"id":16895,"date":"2016-10-13T10:00:08","date_gmt":"2016-10-13T17:00:08","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=16895"},"modified":"2024-01-22T22:50:35","modified_gmt":"2024-01-23T06:50:35","slug":"sql-server-2016-express-edition-in-windows-containers","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/","title":{"rendered":"SQL Server 2016 Express Edition in Windows containers"},"content":{"rendered":"<p>We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our SQL Server Samples GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers.<\/p>\n<p>SQL Server 2016 Express Edition <a href=\"https:\/\/hub.docker.com\/r\/microsoft\/mssql-server-2016-express-windows\/\">Docker Image<\/a><\/p>\n<p>We hope you will find these images useful and leverage them for your container-based applications!<\/p>\n<h2>Why use SQL Server in containers?<\/h2>\n<p>SQL Server 2016 in a Windows container would be ideal when you want to:<\/p>\n<ol>\n<li>Quickly create and start a set of SQL Server instances for development or testing.<\/li>\n<li>Maximize density in test or production environments, especially in microservice architectures.<\/li>\n<li>Isolate and control applications in a multi-tenant infrastructure.<\/li>\n<\/ol>\n<h2>Prerequisites<\/h2>\n<p>Before you can get started with the SQL Server 2016 Express Edition image, you\u2019ll need a Windows Server 2016 or Windows 10 host with the latest updates, the Windows Container feature enabled, and the Docker engine.<\/p>\n<p>Please find the details for each of these requirements below.<\/p>\n<ul>\n<li><b>Get a Windows Server 2016 or Windows 10 host<\/b>\n<ul>\n<li><b>Windows Server 2016<\/b>: You can start by downloading an evaluation copy from the <a href=\"https:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-windows-server-2016?i=1\">TechNet Evaluation Center<\/a>. Please make sure that all the latest Windows updates are installed, most importantly KB3176936 and KB3192366.<\/li>\n<li><b>Windows 10: <\/b>You will need Windows 10 <a href=\"https:\/\/blogs.windows.com\/windowsexperience\/2016\/08\/02\/how-to-get-the-windows-10-anniversary-update\/#gm51DvwQCSTxr4Ee.97\">Anniversary Edition<\/a> Professional or Enterprise. Note: if you are on the Windows Insider builds, make sure that you are using build 14942.1000 or higher to avoid an issue with the Docker run command in older builds.<\/li>\n<\/ul>\n<\/li>\n<li><b>Enable the Windows Container feature and install the Docker Engine<\/b>\n<ul>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/virtualization\/windowscontainers\/quick_start\/quick_start_windows_server\">Quick start for Windows Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/en-us\/virtualization\/windowscontainers\/quick_start\/quick_start_windows_10\">Quick start for Windows 10<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Pulling and Running SQL Server 2016 in a Windows Container<\/h2>\n<p>Below are the Docker pull and run commands for running SQL Server 2016 Express instance in a Windows Container.<\/p>\n<p>Make sure that the mandatory <b>sa_password<\/b> environment variable meets the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms161959.aspx\">SQL Server 2016 Password Complexity requirements<\/a>.<\/p>\n<p><b>First, pull the image<\/b><\/p>\n<p><span style=\"font-family: 'Courier New'\">docker pull microsoft\/mssql-server-2016-express-windows<\/span><\/p>\n<p><b>Then, run a SQL Server container<\/b><\/p>\n<p>Running a Windows Server Container (Windows Server 2016 only):<\/p>\n<p><span style=\"font-family: 'Courier New'\">docker run -d -p 1433:1433 \u2013\u2013env sa_password=&lt;YOUR_PWD&gt; microsoft\/mssql-server-2016-express-windows<\/span><\/p>\n<p>Running a Hyper-V Container (Windows Server 2016 or Windows 10):<\/p>\n<p><span style=\"font-family: 'Courier New'\">docker run -d -p 1433:1433 \u2013\u2013env sa_password=&lt;YOUR_PWD&gt; \u2013\u2013<b>isolation=hyperv<\/b> microsoft\/mssql-server-2016-express-windows<\/span><\/p>\n<h2>Connecting to SQL Server 2016<\/h2>\n<h4>From within the container<\/h4>\n<p>An easy way to connect to the SQL Server instance from <i>inside<\/i> the container is by using the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms162773.aspx\">sqlcmd utility<\/a>.<\/p>\n<p>First, use the <b>docker ps<\/b> command to get the container ID that you want to connect to and use it to replace the parameter placeholder \u2018&lt;DOCKER_CONTAINER_ID&gt;\u2019 in the commands below. You can use the <b>docker exec -it<\/b> command to create an interactive command prompt that will execute commands inside of the container.<\/p>\n<p>You can connect to SQL Server by using either Windows or SQL Authentication.<\/p>\n<p><b>Windows authentication using container administrator account<\/b><\/p>\n<p><span style=\"font-family: 'Courier New'\">docker exec -it &lt;DOCKER_CONTAINER_ID&gt; sqlcmd<\/span><\/p>\n<p><b>SQL authentication using the system administrator (SA) account<\/b><\/p>\n<p><span style=\"font-family: 'Courier New'\">docker exec -it &lt;DOCKER_CONTAINER_ID&gt; sqlcmd -S. -Usa<\/span><\/p>\n<h4>From outside the container<\/h4>\n<p>One of the ways to access SQL Server 2016 from outside the container is by installing <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx\">SQL Server Management Studio (SSMS)<\/a>. You can install and use SSMS either on the host or on another machine that can remotely connect to the host .<\/p>\n<p><b>Connect from SSMS installed on the host <\/b><\/p>\n<p>To connect from SSMS installed on the host, you\u2019ll need the following information:<\/p>\n<ul>\n<li>The IP Address of the container<br \/>\nOne of the ways to get the IP address of the container is by using the <a href=\"https:\/\/docs.docker.com\/engine\/reference\/commandline\/inspect\/\"><b>docker inspect<\/b><\/a> command:<br \/>\n<span style=\"font-family: 'Courier New'\">docker inspect &#8211;format='{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}&#8217; &lt;DOCKER_CONTAINER_ID&gt;<\/span><\/li>\n<li>The SQL Server port number<br \/>\nThis is the same port number that was specified in the <b>docker run<\/b> command. If you used 1433 you don\u2019t need to specify the port. If you want to specify a port to connect to you can add it to the end of the server name like this: myserver,1433.<\/li>\n<li>SQL system administrator account credentials<br \/>\nThe username is \u2018sa\u2019 and the <b>sa_password<\/b> that was used in the docker run command.<\/li>\n<\/ul>\n<p><b>Connect from SSMS on another machine (other than the Host Environment) <\/b><\/p>\n<p>To connect from SSMS installed on another machine (that can connect to the host), you\u2019ll need the following information:<\/p>\n<ul>\n<li>The IP address of the host<br \/>\nYou can get the host\u2019s IP address by using the <b>ipconfig<\/b> command from a PowerShell or command prompt window.<\/li>\n<li>The SQL Server port number<br \/>\nThis is the same port that was specified in the <b>docker run<\/b> command. If you used 1433 you don\u2019t need to specify the port. If you want to specify a port to connect to you can add it to the end of the server name like this: myserver,1433.<br \/>\nNote: Depending on your configuration, you might have to <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms175043.aspx\">create a firewall rule<\/a> to open the necessary SQL Server ports on the host. Please refer to <a href=\"https:\/\/msdn.microsoft.com\/en-us\/virtualization\/windowscontainers\/management\/container_networking\">this<\/a> article for more information regarding container networking.<\/li>\n<li>SQL system administrator account credentials<br \/>\nThe username is \u2018sa\u2019 and the <b>sa_password<\/b> that was used in the docker run command.<\/li>\n<\/ul>\n<h2>SQL 2016 Features Supported on Windows Server Core<\/h2>\n<p>Please refer to <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/hh231669.aspx\">this<\/a> link for all SQL Server 2016 features that are supported on a Windows Server Core installation.<\/p>\n<h2>Developing Using Windows 10 Containers<\/h2>\n<p>Check out this blog post by Alex Ellis, Docker Captain, on how to use SQL Server 2016 Express Edition in a Windows container as part of an application development and test environment on Windows 10.<\/p>\n<p><a href=\"http:\/\/blog.alexellis.io\/docker-does-sql2016-aspnet\/\">Docker with Microsoft SQL 2016 + ASP.NET<\/a><\/p>\n<h2>Further Reading<\/h2>\n<p><a href=\"https:\/\/msdn.microsoft.com\/virtualization\/windowscontainers\/containers_welcome\">Windows Containers Documentation<\/a><br \/>\n<a href=\"https:\/\/channel9.msdn.com\/Blogs\/containers\/Container-Fundamentals--Part-4-Resource-Management\">Container Resource Management<\/a><br \/>\n<a href=\"https:\/\/channel9.msdn.com\/Blogs\/containers\">Tutorials for SQL Server 2016<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our SQL Server Samples GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers.<\/p>\n","protected":false},"author":1457,"featured_media":0,"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,2403],"content-type":[2424,2448],"topic":[2466],"coauthors":[2487],"class_list":["post-16895","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-best-practices","content-type-updates","topic-developer","review-flag-1593580427-503","review-flag-1593580419-556","review-flag-lever-1593580264-545"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2016 Express Edition in Windows containers - 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\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 Express Edition in Windows containers - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our SQL Server Samples GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\" \/>\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-10-13T17:00:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2016 Express Edition in Windows containers\",\"datePublished\":\"2016-10-13T17:00:08+00:00\",\"dateModified\":\"2024-01-23T06:50:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\"},\"wordCount\":934,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\",\"name\":\"SQL Server 2016 Express Edition in Windows containers - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-10-13T17:00:08+00:00\",\"dateModified\":\"2024-01-23T06:50:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#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 2016 Express Edition in Windows containers\"}]},{\"@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 2016 Express Edition in Windows containers - 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\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Express Edition in Windows containers - Microsoft SQL Server Blog","og_description":"We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our SQL Server Samples GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-10-13T17:00:08+00:00","article_modified_time":"2024-01-23T06:50:35+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2016 Express Edition in Windows containers","datePublished":"2016-10-13T17:00:08+00:00","dateModified":"2024-01-23T06:50:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/"},"wordCount":934,"commentCount":8,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/","name":"SQL Server 2016 Express Edition in Windows containers - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-10-13T17:00:08+00:00","dateModified":"2024-01-23T06:50:35+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/13\/sql-server-2016-express-edition-in-windows-containers\/#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 2016 Express Edition in Windows containers"}]},{"@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\/16895","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=16895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=16895"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=16895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=16895"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=16895"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=16895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=16895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}