SQL Server 2017: Linux, Docker, and macOS

SQL Server is not just for Windows anymore. Learn how to install and connect to SQL Server 2017 on Linux, from Docker containers, and from macOS.

Introduction

• Welcome
• What you should know

1. Working in Linux

• Linux prerequisites for SQL Server
• Linux basics

2. Install SQL Server on Ubuntu

• Installing SQL Server on Ubuntu
• Upgrading SQL Server
• Uninstalling SQL Server
• Stop and restart the server

3. Connect to SQL Server on Linux

• Installing mssql-tools
• Run sqlcmd in a Linux terminal
• Issue T-SQL commands
• Install additional services
• Connect using SSMS on Windows

4. Get Started with Docker

• Docker prerequisites for SQL Server
• Install Docker on Windows
• Install Docker on macOS
• Pull the SQL Server image
• Connect to SQL Server within a container
• Connect from outside the container

5. Work in a Docker Container

• Change the SA account password
• Run multiple instances of SQL Server
• Sharing data across containers
• Perform an external backup

6. SQL Tools on macOS

• Understand macOS integration
• Install Homebrew
• tap and brew mssql-tools
• Connect to a SQL Server instance
• Extract data with bcp

7. SQL Operations Center

• What is Operations Studio?
• Get started with Operations Studio
• Write T-SQL commands
• Back up a database

Conclusion

• Next steps