Who does not want to spin up an instance of SQL Server Development version?
If you don’t want to go through the pain of downloading and following the installation wizard in windows you can have an instance of SQL server 2022 running on your system in less than 5 min in docker.
I am assuming 2 things you already have installed in your computer.
This version runs on a linux container.
with all that then follow these steps.
All credit to this article.
make sure the password meet SQL server requirements
at least 10 characters long 1 number 1 capital/lower 1 special character
open your bash prompt on your WSL.
sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=StrongP@ssword42" \ -p 1433:1433 --name sql1 --hostname sql1 \ -d \ mcr.microsoft.com/mssql/server:2022-latest
Ger inside the container
sudo docker exec -it sql1 "bash"
inside the container
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "StrongP@ssword42"
create a DB, Table and insert some data
CREATE DATABASE TestDB; GO
USE TestDB; CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT); INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154); GO
SELECT * FROM Inventory GO
To connect via SQL Server Management Studio from your local machine.
server name :
user name :
before pressing connect make sure you mark trust server certificate
then your server is ready to go
have fun ! 😀