SQL Server Learnings

I followed this guide to set up the MS-SQL DB.

Examples seen are loosely based of the Microsoft learning path for Transact-SQL

Key commands

desired action	command
open docker shell	docker exec -it sql1 "bash"
connect cmdsql to docker container	sqlcmd -S localhost,1433 -U sa -P Mssqlserver1!

Database connection values

key	value
Server type	Database Engine
Server name	localhost,1433
Authentication	SQL Server Authentication
Login	sa
Password	Mssqlserver1!