How to Install SQL Server on MacOS with docker

I'm writing a small tut for who need to install SQL Server on macOS using docker

Step 1: Download the SQL Server Image

sudo docker pull mcr.microsoft.com/mssql/server:2019-latest

Step 2: Launch the SQL Server Image in Docker

docker run -d --name example_sql_server -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pass.word-123' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest

Step 3: Check the SQL Server Docker Container

docker ps -a

Step 4: Install SQL Server Command-Line Tool

sudo npm install -g sql-cli

Step 5: Connect to SQL Server

5.1 Using Command

mssql -u sa -p Pass.word-123

5.2: Using VSCode to connect to sql server

Using the extension SQL Server (mssql)

Comments

Text manipulation: Find and replace Linux commands

Text manipulation is a key aspect of working with text data in various fields such as data science, data engineering, web development, and system administration. There are many tools and techniques available for text manipulation in Linux or Unix-based systems. Some popular tools for text manipulation include:

What is API Gateway?

What does API gateway do? The diagram below shows the detail. Step 1 - The client sends an HTTP request to the API gateway. Step 2 - The API gateway parses and validates the attributes in the HTTP request. Step 3 - The API gateway performs allow-list/deny-list checks. Step 4 - The API gateway talks to an identity provider for authentication and authorization. Step 5 - The rate limiting rules are applied to the request. If it is over the limit, the request is rejected. Steps 6 and 7 - Now that the request has passed basic checks, the API gateway finds the relevant service to route to by path matching. Step 8 - The API gateway transforms the request into the appropriate protocol and sends it to backend microservices. Steps 9-12 : The API gateway can handle errors properly, and deals with faults if the error takes a longer time to recover (circuit break). It can also leverage ELK (Elastic-Logstash-Kibana) stack for logging and monitoring. We sometimes cache data in the API gatew...

Quoc Trinh

Search This Blog