SQL Server Database Instance on Docker (with VS Code!) - Windows

Scripts used:

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=P@SSw0rd!" -e "MSSQL_PID=Evaluation" -p 1433:1433 --name verbtablessql --hostname verbtablessql -v C:\\Users\\ME\\Documents\\DockerVolumes:/var/opt/mssql/data -v C:\\Users\\ME\\Documents\\DockerVolumes:/var/opt/mssql/logs -v C:\\Users\\ME\\Documents\\DockerVolumes:/var/opt/mssql/secrets -d mcr.microsoft.com/mssql/server:2022-latest

=====

Database scripts:

Create Database VerbTables;

Create TABLE Verbs (
ID INT IDENTITY(1, 1) PRIMARY KEY,
Infinitive NVARCHAR(50)
);


-- Insert data into the Verbs table
INSERT INTO Verbs (Infinitive)
VALUES ('speak'), ('listen');
GO

==========================
Remember - it's never too late!

Cheers,
Steve