Posts

Visual Studio Code and T-SQL on SQLServeronLinux

Image
As a follow up blog on working with SQL server on Linux(Original Blog - http://learningdatabaseguy.blogspot.com.au/2017/11/setup-sql-server-instance-on-linux-on.html) , I have decided to use Visual Studio Code (https://code.visualstudio.com/ ) to connect to SQL server instance on Linux running on docker. To refresh our minds, we can use below command to check the SQL server running process:  192-168-1-10:~ ashwi$ docker ps CONTAINER ID        IMAGE                                   COMMAND                  CREATED STATUS              PORTS                    NAMES 187d5a935fe6        microsoft/mssql-server-linux:2017-GDR   "/bin/sh -c /opt/m..."   21 hours ago Up 21 hours      ...
Post a Comment
Read more

Setup SQL Server instance on Linux on Docker

Image
This blog post talks about the setup of a SQL server instance on a Linux machine running on Docker. The versions of the softwares used are mentioned below: Docker : Community Edition Version 17.06.1-ce-mac24 (18950) OS of machine running Docker : MacOS Sierra 10.12.6 SQL server :  Microsoft SQL Server 2017 (RC2) - 14.0.900.75 (X64)                     Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS) DBeaver :  Community Edition 4.2.5 Steps taken for this setup were as follows: (1)  Pull and run the container image.  Pull the SQL Server 2017 Linux container image from Docker Hub. (a) Launch Terminal application and type the below command:  sudo docker pull microsoft/mssql-server-linux:2017-latest (b) To run the container image with Docker, you can use the following command from a bash shell (Linux/macOS): 192-168-1-8:~ ashwi$ docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=xxxxxx' -e 'M...
Post a Comment
Read more