Microsoft SQL Server 2017: Linux, Docker and macOS Hands-On

Explore Linux prerequisites for SQL Server and the Ubuntu, Red Hat, and SUSE distributions, with subscription and free options, plus 64-bit and 6 GB disk requirements.

Demonstrate Linux basics on a desktop, using the Unity dashboard, dash search, file explorer, and commands like ls, cd, and touch, then prep for SQL Server 2017 installation on Linux.

Follow a beginner-friendly, step-by-step guide to install Ubuntu, covering drive space, location, keyboard layout, and login details. Complete the final installation step and start using Ubuntu on your system.

Learn to upgrade SQL Server 2017 on Linux using the system package manager, verify repository updates, and reinstall to overwrite changed files, with apt or yum depending on distro.

Learn to stop and start SQL Server 2017 on Linux using systemctl, and verify active status of the server via command line.

Install mssql-tools on Linux by adding the official repository, updating packages, and installing mssql-tools with unixodbc. Use sqlcmd and bcp to run sql statements and bulk-load data.

Set the path to sqlcmd for use from any directory on Linux, then connect to SQL Server 2017 and run a query to show the version and databases.

Execute SQL commands on Linux to create databases and tables, insert records, and run scripts using sqlcmd, demonstrating end-to-end database setup in a hands-on lab.

Install additional services for SQL Server on Linux, including full text search and integration services, using similar apt-get installation steps and restart SQL Server as needed.

Connect from Windows SQL Server Management Studio to a Linux-based SQL Server using the server IP, credentials, and view the employee table.

Learn docker prerequisites for SQL Server: install docker engine 1.8+, run on Linux, macOS, or Windows, allocate minimum 2 GB storage and RAM, and use tagged images with developer edition.

Learn to install Docker on Windows by downloading Docker Desktop Community Edition, enabling Hyper-V and container features, and starting Docker to verify the version and run commands.

install Docker desktop for mac from the community edition, drag to applications, start it, and verify with docker --version. observe the default memory is 2 gigabytes.

pull and run the Microsoft SQL Server Docker image on Linux or macOS, select the tag, accept the license, set a strong sa password, and map host ports.

Connect to SQL Server inside a Docker container from the host using bash, then create a database and cards table with id, name, price, insert a record, and query it.

Connect from another computer to a SQL Server in a Docker container using port 1401 and the host IP, then log in with sqlcmd on Linux and list databases.

Demonstrates how the sa password in a docker container can be exposed by a simple command, then changes it inside the container with sqlcmd.

Learn to spin up multiple SQL Server 2017 instances with Docker, using pre-downloaded Microsoft images, unique container names and ports, and connect via host IP and mapped ports.

Learn to persist and share sql server data across docker containers by using named volumes mapped to host directories, then stop, recreate, and attach multiple containers to the same volume.

Back up a database inside a SQL Server container and copy the backup out to your host. Archive or transfer the file to your desktop.

Understand macOS integration by using sqlcmd to connect to sql server instances locally or in containers, and install the tool on macOS via an unofficial package manager called homebrew.

Install homebrew on macOS via a script in the terminal, paste commands, and authorize with your password to manage packages. Explore formulas and dependencies and use brew help.

Learn to install mssql-tools on macOS with Homebrew by tapping the Microsoft Homebrew repo, installing msodbcql first, accepting licenses, and verifying with sqlcmd.

Connect to a sql server instance from macOS using sqlcmd via homebrew, specify ip address and port, verify the server is up, and list databases with a sample query.

Explore using the bcp utility to load or export data with a database, including table, schema, and external file selection, and producing Unicode, tab-delimited output.

Discover Microsoft Operations Studio, a cross-platform tool for SQL Server management. Connect to multiple servers, write SQL with IntelliSense, and work in a tabbed interface across Windows, macOS, and Linux.

Get started with operations studio to connect to a SQL Server instance running in a docker container using localhost and port 1401, log in, and explore the interface.

Explore writing T-SQL commands in a full editor with IntelliSense, code highlighting, and snippets to write and execute queries, create tables, and view execution plans.

Learn how to back up a database using the UI, choose backup type (full, differential, or log), name with date, set location, enable compression or encryption, and verify the backup.