...
This guide will show the process for installing SQL Server 2019 and SQL Server Management Studio (SSMS) on your workstation.
| Info |
|---|
SQL Server 2019 Developer and SSMS are only available in This installation guide is only applicable to Windows.However, there are ways to install SQL Server using Docker and interact with it using third-party software like DBeaver. |
On macOS environment, you will need to run Microsoft SQL Server in a Docker container and interface with the database using compatible Database client, such as Azure Data Studio.
Installation guides:
Intel - https://database.guide/how-to-install-sql-server-on-a-mac/
Arm64 (M1, M2) - https://database.guide/how-to-install-sql-server-on-an-m1-mac-arm64/
...
Preface
To setup SQL Server in your workstation, you need to have at least the core function installed. The SQL Server installer will install the back-end service(s) that handle the database, while SQL Server Management Studio (SSMS) is responsible for providing the interface to access and interact with the database. Everything you do will go through a database manager before the changes are reflected in the database.
...