SQL Server on Linux

Intermediate
Data Engineer
SQL Server

SQL Server now runs on your choice of operating system. In this learning path you will discover the fundamentals of SQL Server on Linux, before discovering how to run SQL Server on Linux containers and deploy SQL Server on Linux. You will then learn how to automatically tune your SQL Server on Linux deployment.

Prerequisites

Basic understanding of Linux administration and administration of relational databases.

Modules in this learning path

Learn the benefits of installing SQL Server on Linux.

Learn about the software and hardware prerequisites to run SQL Server on Linux and then discover the straightforward steps to install SQL Server on Linux. You will also learn additional tasks, such as installing command-line tools.

Use Azure Data Studio to supplement performance data from Dynamic Management Views (DMVs) and display how your SQL Server 2019 system performs over time. Investigate query plan regressions and then use the Query Store and automatic tuning to mitigate their effect.

Containers provide isolated virtual environments in which you can run applications such as SQL Server 2019 and are growing in popularity because of their scalability. If you choose SQL Server 2019 to host your databases, you can run that system in one or more containers based on either Linux or Windows. You can create a container from an image that has SQL Server pre-installed or create your own customized image. In this module, you will see how to run SQL Server 2019 in Linux containers and host a custom database application.