{"id":11492,"date":"2018-07-27T12:33:43","date_gmt":"2018-07-27T10:33:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/"},"modified":"2023-07-13T16:32:25","modified_gmt":"2023-07-13T14:32:25","slug":"running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/","title":{"rendered":"Running SQL Server containers on K8s Docker for Windows CE stable channel"},"content":{"rendered":"<p>The release of Docker for Windows Stable version <a href=\"https:\/\/docs.docker.com\/docker-for-windows\/release-notes\/#stable-releases-of-2018\">18.06..0-ce-win70<\/a> comes with some great new features I looked for a while including the K8s support! That\u2019s a pretty good news because this support has existed on <a href=\"https:\/\/blog.docker.com\/2018\/01\/docker-windows-desktop-now-kubernetes\/\">Edge channel<\/a> since the beginning of this year but no chance to install a beta version on my laptop from my side.<\/p>\n<p>So, we get now a good opportunity to test locally our SQL Server image with a K8s single node architecture.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-25742 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg\" alt=\"blog 141 - 1 -docker 18.06.0-ce-win72\" width=\"600\" height=\"369\" \/><\/p>\n<p>One interesting point here is I may switch the context of K8s infrastructure as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25743\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-2-docker-k8s-switch-context.jpg\" alt=\"blog 141 - 2 -docker k8s switch context\" width=\"581\" height=\"385\" \/><\/p>\n<p>The first one (dbi8scluster) corresponds to my K8s cluster on Azure. I wrote <a href=\"https:\/\/www.dbi-services.com\/blog\/introducing-sql-server-on-kubernetes\/\">about it<\/a> some time ago and the second one is about my single K8s node on my Windows 10 laptop. So, switching to my different environments is very easy as shown below:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">[dab@DBI:$]&gt; kubectl get nodes\nNAME                       STATUS     ROLES     AGE       VERSION\naks-nodepool1-78763348-0   NotReady   agent     57d       v1.9.6\naks-nodepool1-78763348-1   NotReady   agent     57d       v1.9.6\nC:\\Users\\dab\\Desktop\n[dab@DBI:$]&gt; kubectl get nodes\nNAME                 STATUS    ROLES     AGE       VERSION\ndocker-for-desktop   Ready     master    1d        v1.10.3\nC:\\Users\\dab\\Desktop<\/pre>\n<p>It is also interesting to get a picture of the container installed and that run the K8s infrastructure on Docker. Assuming you already enabled the showing system containers option in advanced mode you may display all the K8s related containers as following:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">[dab@DBI:$]&gt; docker ps --format \"table {{.ID}}\\t {{.Names}}\"\nCONTAINER ID         NAMES\n829a5941592e         k8s_compose_compose-7447646cf5-l5shp_docker_7e3ff6d9-908e-11e8-91f0-00155d0013a6_4\n53666469f25d         k8s_compose_compose-api-6fbc44c575-7jrj8_docker_7e3ff0d0-908e-11e8-91f0-00155d0013a6_4\ncd3772216e72         k8s_sidecar_kube-dns-86f4d74b45-v7mr9_kube-system_7e3cb79b-908e-11e8-91f0-00155d0013a6_4\n8ae73505dfb0         k8s_dnsmasq_kube-dns-86f4d74b45-v7mr9_kube-system_7e3cb79b-908e-11e8-91f0-00155d0013a6_4\n8066fbefc371         k8s_kubedns_kube-dns-86f4d74b45-v7mr9_kube-system_7e3cb79b-908e-11e8-91f0-00155d0013a6_4\n2591d102e6fb         k8s_kube-proxy_kube-proxy-p9jv9_kube-system_7e43eaab-908e-11e8-91f0-00155d0013a6_4\n80f6d997a225         k8s_POD_compose-7447646cf5-l5shp_docker_7e3ff6d9-908e-11e8-91f0-00155d0013a6_4\n23751c4fd2fc         k8s_POD_kube-proxy-p9jv9_kube-system_7e43eaab-908e-11e8-91f0-00155d0013a6_4\nf96406dedefb         k8s_POD_compose-api-6fbc44c575-7jrj8_docker_7e3ff0d0-908e-11e8-91f0-00155d0013a6_4\n9149e9b91fd3         k8s_POD_kube-dns-86f4d74b45-v7mr9_kube-system_7e3cb79b-908e-11e8-91f0-00155d0013a6_4\n2316ed63e2ee         k8s_kube-controller-manager_kube-controller-manager-docker-for-desktop_kube-system_120c685a17dc3d67e505450a6ea9243c_4\n52defb42bbaf         k8s_kube-apiserver_kube-apiserver-docker-for-desktop_kube-system_814863b48e4b523c13081a7bb4c85f0d_4\n3366ebf8f058         k8s_kube-scheduler_kube-scheduler-docker-for-desktop_kube-system_ea66a171667ec4aaf1b274428a42a7cf_4\nbd903b9dce3f         k8s_etcd_etcd-docker-for-desktop_kube-system_d82203d846b07255217d0e72211752f0_4\n7e650673b6d2         k8s_POD_kube-apiserver-docker-for-desktop_kube-system_814863b48e4b523c13081a7bb4c85f0d_4\n24e4bfb59184         k8s_POD_kube-scheduler-docker-for-desktop_kube-system_ea66a171667ec4aaf1b274428a42a7cf_4\n3422edb44165         k8s_POD_etcd-docker-for-desktop_kube-system_d82203d846b07255217d0e72211752f0_4\naeca6879906b         k8s_POD_kube-controller-manager-docker-for-desktop_kube-system_120c685a17dc3d67e505450a6ea9243c_4<\/pre>\n<p>We retrieve all the K8s components including the API server, the controller manager, the K8s scheduler, the kube-proxy and the etcd cluster database. It is not my intention to go further on this topic and I will probably get the opportunity to dig further in the next blog posts.<\/p>\n<p>My first test consisted in deploying our dbi services custom image for development about SQL Server 2017 Linux on my K8s cluster node. I already did it with our dbi services production image on my previous K8s infrastructure on Azure and it could be interesting to check if we have to operate in the same way. This is at least what I expected and I was right. Just note \u00a0I didn&#8217;t\u00a0perform the same test\u00a0with Windows containers yet but it will be soon hopefully.<\/p>\n<p>Obviously, I had to change my storage classes to StorageClassName = hostpath to point to my host storage as follows:<\/p>\n<pre class=\"brush: xml; gutter: true; first-line: 1\">kind: PersistentVolume\napiVersion: v1\nmetadata:\n  name: pv-data-sql\n  labels:\n    type: local\nspec:\n  storageClassName: hostpath\n  capacity:\n    storage: 10Gi\n  accessModes:\n    - ReadWriteOnce\n  hostPath:\n    path: \/T\/Docker\/DMK\/BACKUP\n---\nkind: PersistentVolumeClaim\napiVersion: v1\nmetadata:\n  name: pv-claim-data-sql\nspec:\n  storageClassName: hostpath\n  accessModes:\n    - ReadWriteOnce\n  resources:\n    requests:\n      storage: 10Gi<\/pre>\n<p>I just want to draw your attention to the hostPath because we have to apply some modifications from the initial path to be understood by K8s. On Windows side my path is <em>T:\/Docker\/DMK\/BACKUP<\/em> and it contains a backup of my custom <em>AdventureWorks<\/em> database for our tests.<\/p>\n<p>Here the command to deploy my persistence volume and the correspond persistent volume claim that will be used by my SQL Server pod:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">[dab@DBI:$]&gt; kubectl create -f .\\docker_k8s_storage.yaml\npersistentvolume \"pv-data-sql\" created\npersistentvolumeclaim \"pv-claim-data-sql\" created<\/pre>\n<p>Then my development file didn\u2019t change a lot as expected:<\/p>\n<pre class=\"brush: xml; gutter: true; first-line: 1\">apiVersion: apps\/v1beta1\nkind: Deployment\nmetadata:\n  name: mssql-deployment\nspec:\n  replicas: 1\n  template:\n    metadata:\n      labels:\n        app: mssql\n    spec:\n      terminationGracePeriodSeconds: 10\n      volumes:\n      - name: mssqldb\n        persistentVolumeClaim:\n          claimName: pv-claim-data-sql\n      containers:\n      - name: mssql\n        image: dbi\/dbi_linux_sql2017:2017-CU4\n        ports:\n        - containerPort: 1433\n        env:\n        - name: ACCEPT_EULA\n          value: \"Y\"\n        - name: MSSQL_SA_PASSWORD\n          value: \"Password1\"\n          # valueFrom:\n          #   secretKeyRef:\n          #     name: mssql\n          #     key: SA_PASSWORD \n        - name: DMK\n          value: \"Y\"\n        volumeMounts:\n        - name: mssqldb\n          mountPath: \"\/backup\"\n---\napiVersion: v1\nkind: Service\nmetadata:\n  name: mssql-deployment\nspec:\n  selector:\n    app: mssql\n  ports:\n    - protocol: TCP\n      port: 1433\n      targetPort: 1433\n  type: LoadBalancer<\/pre>\n<p>The command to deploy my SQL Server container pod and the correspond service is:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[dab@DBI:$]&gt; kubectl create -f .\\docker_k8s_sql.yaml\ndeployment.apps \"mssql-deployment\" created\nservice \"mssql-deployment\" created<\/pre>\n<p>So, let\u2019s get a picture of my new deployed environment:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">[dab@DBI:$]&gt; kubectl get deployments\nNAME               DESIRED   CURRENT   UP-TO-DATE   AVAILABLE   AGE\nmssql-deployment   1         1         1            1           2m\n\n[dab@DBI:$]&gt; kubectl get services\nNAME               TYPE           CLUSTER-IP      EXTERNAL-IP   PORT(S)          AGE\nkubernetes         ClusterIP      10.96.0.1       &lt;none&gt;        443\/TCP          1d\nmssql-deployment   LoadBalancer   10.109.238.88   localhost     1433:30200\/TCP   2m\n\n[dab@DBI:$]&gt; kubectl get pods -o wide\nNAME                                READY     STATUS    RESTARTS   AGE       IP          NODE\nmssql-deployment-6c69bb6f7c-pqb2d   1\/1       Running   0          7m        10.1.0.39   docker-for-desktop<\/pre>\n<p>Everything seems to be deployed successfully. I use a load balancer service here but\u00a0bear in mind I just have\u00a0only one node.\u00a0Here a description of my new deployed pod:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">[dab@DBI:$]&gt; kubectl describe pod mssql-deployment-6c69bb6f7c-pqb2d\nName:           mssql-deployment-6c69bb6f7c-pqb2d\nNamespace:      default\nNode:           docker-for-desktop\/192.168.65.3\nStart Time:     Fri, 27 Jul 2018 12:45:50 +0200\nLabels:         app=mssql\n                pod-template-hash=2725662937\nAnnotations:    &lt;none&gt;\nStatus:         Running\nIP:             10.1.0.39\nControlled By:  ReplicaSet\/mssql-deployment-6c69bb6f7c\nContainers:\n  mssql:\n    Container ID:   docker:\/\/a17039dcdcb22c1b4b80c73fb17e73df90efda19ed77e215ef92bf86c9bfc538\n    Image:          dbi\/dbi_linux_sql2017:2017-CU4\n    Image ID:       docker:\/\/sha256:2a693c121c33c390f944df7093b8c902f91940fa966ae8e5190a7a4a5b0681d2\n    Port:           1433\/TCP\n    Host Port:      0\/TCP\n    State:          Running\n      Started:      Fri, 27 Jul 2018 12:45:51 +0200\n    Ready:          True\n    Restart Count:  0\n    Environment:\n      ACCEPT_EULA:        Y\n      MSSQL_SA_PASSWORD:  Password1\n      DMK:                Y\n    Mounts:\n      \/backup from mssqldb (rw)\n      \/var\/run\/secrets\/kubernetes.io\/serviceaccount from default-token-5qts2 (ro)\nConditions:\n  Type           Status\n  Initialized    True\n  Ready          True\n  PodScheduled   True\nVolumes:\n  mssqldb:\n    Type:       PersistentVolumeClaim (a reference to a PersistentVolumeClaim in the same namespace)\n    ClaimName:  pv-claim-data-sql\n    ReadOnly:   false\n  default-token-5qts2:\n    Type:        Secret (a volume populated by a Secret)\n    SecretName:  default-token-5qts2\n    Optional:    false\nQoS Class:       BestEffort\nNode-Selectors:  &lt;none&gt;\nTolerations:     node.kubernetes.io\/not-ready:NoExecute for 300s\n                 node.kubernetes.io\/unreachable:NoExecute for 300s\nEvents:\n  Type    Reason                 Age   From                         Message\n  ----    ------                 ----  ----                         -------\n  Normal  Scheduled              3m    default-scheduler            Successfully assigned mssql-deployment-6c69bb6f7c-pqb2d to docker-for-desktop\n  Normal  SuccessfulMountVolume  3m    kubelet, docker-for-desktop  MountVolume.SetUp succeeded for volume \"pv-data-sql\"\n  Normal  SuccessfulMountVolume  3m    kubelet, docker-for-desktop  MountVolume.SetUp succeeded for volume \"default-token-5qts2\"\n  Normal  Pulled                 3m    kubelet, docker-for-desktop  Container image \"dbi\/dbi_linux_sql2017:2017-CU4\" already present on machine\n  Normal  Created                3m    kubelet, docker-for-desktop  Created container\n  Normal  Started                3m    kubelet, docker-for-desktop  Started container<\/pre>\n<p>And finally, let&#8217;s have a look at a sample of my SQL Server log:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">========================== 2018-07-27 10:46:43 Restoring AdventureWorks database OK ==========================\n========================== 2018-07-27 10:46:43 Installing TSQLt ==========================\n2018-07-27 10:46:44.01 spid51      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.\nConfiguration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.\n2018-07-27 10:46:44.02 spid51      Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.\n2018-07-27 10:46:44.02 spid51      Configuration option 'clr strict security' changed from 1 to 0. Run the RECONFIGURE statement to install.\n2018-07-27 10:46:44.02 spid51      Configuration option 'max server memory (MB)' changed from 2147483647 to 3072. Run the RECONFIGURE statement to install.\nConfiguration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.\nConfiguration option 'clr strict security' changed from 1 to 0. Run the RECONFIGURE statement to install.\nConfiguration option 'max server memory (MB)' changed from 2147483647 to 3072. Run the RECONFIGURE statement to install.\n2018-07-27 10:46:47.39 spid51      Starting up database 'dbi_tools'.\n2018-07-27 10:46:47.72 spid51      Parallel redo is started for database 'dbi_tools' with worker pool size [2].\n2018-07-27 10:46:47.74 spid51      Parallel redo is shutdown for database 'dbi_tools' with worker pool size [2].\nInstalled at 2018-07-27 10:46:47.863\n2018-07-27 10:46:48.54 spid51      AppDomain 3 (dbi_tools.dbo[runtime].2) created.\n\n(1 rows affected)\n\n+-----------------------------------------+\n|                                         |\n| Thank you for using tSQLt.              |\n|                                         |\n| tSQLt Version: 1.0.5873.27393           |\n|                                         |\n+-----------------------------------------+\n0\n========================== 2018-07-27 10:46:49 Installing TSQLt OK ==========================\n======= 2018-07-27 10:46:49 MSSQL CONFIG COMPLETED =======\n2018-07-27 10:51:03.35 spid55      Using 'dbghelp.dll' version '4.0.5'\n2018-07-27 10:51:10.32 spid55      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.\n2018-07-27 10:51:10.40 spid55      Using 'xplog70.dll' version '2017.140.3022' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.<\/pre>\n<p>My SQL Server pod is mounted with my restored AdventureWorks database accessible from my \/backup path inside my container. We also added to the image, the tSQLt framework for our unit tests.<\/p>\n<p>Let\u2019s connect to my SQL Server pod by using mssql-cli CLI:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">C:\\WINDOWS\\system32&gt;mssql-cli -S localhost -U sa -P Password1\nVersion: 0.15.0\nMail: sqlcli@microsoft.com\nHome: http:\/\/github.com\/dbcli\/mssql-cli\nmaster&gt;\n\nTime: 0.000s\nmaster&gt; select name from sys.databases;\n+--------------------+\n| name               |\n|--------------------|\n| master             |\n| tempdb             |\n| model              |\n| msdb               |\n| AdventureWorks_dbi |\n| dbi_tools          |\n+--------------------+\n(6 rows affected)\nTime: 0.406s<\/pre>\n<p>My first deployment is successful. There are plenty of topics to cover about K8s and SQL Server containers and other writes-up will come soon for sure. Stay tuned!<\/p>\n<p><span style=\"float: none; background-color: #ffffff; color: #333333; cursor: text; font-family: Georgia,'Times New Roman','Bitstream Charter',Times,serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none;\">By David Barbarin<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The release of Docker for Windows Stable version 18.06..0-ce-win70 comes with some great new features I looked for a while including the K8s support! That\u2019s a pretty good news because this support has existed on Edge channel since the beginning of this year but no chance to install a beta version on my laptop from [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":11493,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,1320,99],"tags":[720,601,1407,1365,89,73,51],"type_dbi":[],"class_list":["post-11492","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-devops","category-sql-server","tag-container","tag-docker","tag-docker-for-windows","tag-k8s","tag-kubernetes","tag-linux","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Running SQL Server container on K8s Docker for Windows CE stable channel<\/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.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Running SQL Server containers on K8s Docker for Windows CE stable channel\" \/>\n<meta property=\"og:description\" content=\"The release of Docker for Windows Stable version 18.06..0-ce-win70 comes with some great new features I looked for a while including the K8s support! That\u2019s a pretty good news because this support has existed on Edge channel since the beginning of this year but no chance to install a beta version on my laptop from [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-27T10:33:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-13T14:32:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"369\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"Running SQL Server containers on K8s Docker for Windows CE stable channel\",\"datePublished\":\"2018-07-27T10:33:43+00:00\",\"dateModified\":\"2023-07-13T14:32:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/\"},\"wordCount\":589,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg\",\"keywords\":[\"container\",\"Docker\",\"Docker for Windows\",\"k8s\",\"kubernetes\",\"Linux\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"DevOps\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/\",\"name\":\"Running SQL Server container on K8s Docker for Windows CE stable channel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg\",\"datePublished\":\"2018-07-27T10:33:43+00:00\",\"dateModified\":\"2023-07-13T14:32:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg\",\"width\":600,\"height\":369},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Running SQL Server containers on K8s Docker for Windows CE stable channel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/microsoft-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Running SQL Server container on K8s Docker for Windows CE stable channel","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.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/","og_locale":"en_US","og_type":"article","og_title":"Running SQL Server containers on K8s Docker for Windows CE stable channel","og_description":"The release of Docker for Windows Stable version 18.06..0-ce-win70 comes with some great new features I looked for a while including the K8s support! That\u2019s a pretty good news because this support has existed on Edge channel since the beginning of this year but no chance to install a beta version on my laptop from [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/","og_site_name":"dbi Blog","article_published_time":"2018-07-27T10:33:43+00:00","article_modified_time":"2023-07-13T14:32:25+00:00","og_image":[{"width":600,"height":369,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"Running SQL Server containers on K8s Docker for Windows CE stable channel","datePublished":"2018-07-27T10:33:43+00:00","dateModified":"2023-07-13T14:32:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/"},"wordCount":589,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg","keywords":["container","Docker","Docker for Windows","k8s","kubernetes","Linux","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","DevOps","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/","url":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/","name":"Running SQL Server container on K8s Docker for Windows CE stable channel","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg","datePublished":"2018-07-27T10:33:43+00:00","dateModified":"2023-07-13T14:32:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-141-1-docker-18.06.0-ce-win72-e1532693561400.jpg","width":600,"height":369},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/running-sql-server-containers-on-k8s-docker-for-windows-ce-stable-channel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Running SQL Server containers on K8s Docker for Windows CE stable channel"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11492"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11492\/revisions"}],"predecessor-version":[{"id":26694,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11492\/revisions\/26694"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11493"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11492"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}