Microsoft SQL Server on Linux: Install, setup, connect using SQLCMD & Management Studio Remotely.

If you're looking to install and set up Microsoft SQL Server on Linux, this video is for you. Join us as we guide you through the step-by-step process of installing and configuring SQL Server on the Linux operating system. Whether you're a beginner or an experienced user, this video will provide all the information you need to successfully set up and start using SQL Server on your Linux machine.

In this video, you'll learn these points:
1. Launching new Linux Server instance
2. Downloading and Installing Microsoft SQL Server on Linux
3. Running SQL queries from linux server
4. Connecting to server via SQL Server Management Studio remotely

Commands for installing server:
Step 1. sudo yum update -y
Step 3. sudo yum install -y mssql-server

Configuring:
Step 1. sudo /opt/mssql/bin/mssql-conf setup
Step 2. systemctl status mssql-server

Installing SQLCMD
Step 2. sudo yum install -y mssql-tools18 unixODBC-devel
Step 3. echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' ~/.bashrc
Step 4. source ~/.bashrc

Running SQL Queries
sqlcmd -S . -U userid -P password -C