Managing data is usually a somewhat complex task since there are many types of this data and in addition to them, parameters such as tables, queries and other elements must be created that link and relate the data to each other to provide the necessary answers when the time is right. To help manage all this in a simple but complete way, we have SQL Server 2019..
SQL Server 2019 consists of a platform to manage data with a follow, dynamic and modern approach, this is achieved since SQL Server has a reliable engine compatible with the T-SQL dialect so that as developers we are able to create resistant applications and high perfomance.
SQL Server 2019 Elements
SQL Server 2019 is made up of various elements that make it unique, such as:
- Adding the Platform Abstraction Layer (PAL) in SQL Server to run on Linux
- Support for Ubuntu, Red Hat Enterprise Linux, and SUSE operating systems
- Spark and Apache Hadoop File System (HDFS) support
- Integrates a server engine which can be run on Edge devices and the ARM platform
- Supports programming languages such as T-SQL, Java, C / C ++, Scala, Node.js, C # / VB.NET, Python, Ruby and .NET Core
To use SQL Server 2019 correctly, the following will be necessary at the hardware level:
- 1GB memory (4GB recommended)
- 6 GB of available hard disk space
- 1.4 GHz or faster x64 processor (2 GHz recommended)
SQL Server 2019 has access to information through relational, non-relational, structured and unstructured data queries so that the access options to this type of details are not limited.
SQL Server 2019 is compatible with macOS and getFastAnswer will explain the step by step to install it there..
To stay up to date, remember to subscribe to our YouTube channel! SUBSCRIBE
How to install SQL Server 2019 on macOS
The first thing will be to install Docker, this is an application with which it is possible to create and share applications and microservices in containers directly in the system, Docker integrates functions and plug-ins such as Docker Engine, Docker CLI Client, Docker Compose, Notary, Kubernetes and Credential Helper .
Docker has a set of certified templates and image libraries in Docker Hub to make use of secure repositories and to extend the capabilities of applications to the maximum.
Docker has features such as
- Ease of containing and sharing various applications on any cloud platform, various languages and frameworks available
- Integrate the latest version of Kubernetes
- Ability to work natively on Linux via WSL 2 on Windows machines
- Reliable performance for native Windows Hyper-V virtualization
- Volume mount for code and data
- Containerized development and debugging with supported IDEs
We are going to download Docker for macOS at the following link:
There we select if our macOS has an Intel or Apple chip, then by clicking on the correct version we will see the following. Click Allow to download Docker.
We execute the downloaded file and it will be verified:
After this verification, we will see the following:
We drag the executable to Applications, the copy process will take place:
We access Applications and open Docker there:
Docker verification will start:
At the end, the following message will be displayed:
We click Open to access and we will receive the following warning:
We click OK and enter the administrator password:
We click on "Install auxiliary tool" to complete the process and open Docker in macOS:
When loading the configuration we will see this:
Click on the Docker icon and select "Preferences":
In the "Resources" section we expand the RAM memory. We click on "Apply & Restart" to complete the process.
After this we access the terminal in macOS and download the version of SQL Server for Linux:
docker pull microsoft / mssql-server-linux
The process of downloading, removing and installing the components will take place:
At the end of the process we will see the following:
At the end of this we will access the Docker dashboard and we will see that there is no active container:
Let's go back to the terminal, there we run the SQL Server 2019 container:
docker run -d --name MySQLServer -e 'ACCEPT_EULA = Y' -e 'SA_PASSWORD = Passwordxxxxxx #' -p 1433: 1433 microsoft / mssql-server-linux
The parameters described here are:
- -e ACCEPT_EULA = Y: Refers to our acceptance of Microsoft's EUA (End User License Agreement).
- -e SA_PASSWORD: the system administrator password for SQL Server is set there, this password must be at least 8 characters long and have characters from at least 3 sections such as uppercase letters, lowercase letters, numbers and symbols
- The -p parameter allows to use 1433 as the TCP port number
- --name defines the instance name in sqlserver2019
- -d runs the docker in daemon mode, this is used to run the container in the background
We assign the desired password in Password.
We access the Docker dashboard again and the container will be active:
The next step will be to download Azure Data Studio for macOS, Azure Data Studio is a database tool for various platforms with which it is possible to manage local data and in the cloud on systems such as Windows, macOS and Linux, its download is available at the following link:
Azure Data Studio
We download the ZIP file, we must accept the download:
Once downloaded, we run Azure Data Studio:
Click on Open to proceed with the opening, we will see the following. We click on "New connection"
We enter the values:
- authentication type: SQL Login
We create the connection by clicking on "Connect", this will link with SQL Server 2019:
We navigate in the different options of use:
From Home it is possible to access the structure of SQL Server 2019:
We click on "New Query", we will create the database with the syntax "CREATE DATABASE Name":
We select the line and click on Run to execute it:
When executed we will see the following:
We right click on Databases and select the "Refresh" option in order to see the database created:
This has been the step by step to install one of the most popular tools to manage data such as SQL Server 2019.