Sample SQL Server Database and Docker смотреть онлайн

https://www.codingblocks.net

In this video we go over how to get a good sized chunk of data to get you started with SQL Server. This video completes the foundation for upcoming video on learning many SQL Server related tips. If you haven't already, you'll likely want to watch the first video in the series so you can follow this one with a better understanding. That video can be found here:
https://www.youtube.com/watch?v=gJs0vzSzB9c

Some helpful notes from the video:
Contoso Sample BI Database Download
https://www.microsoft.com/en-us/download/details.aspx?id=18279

Run a container and kill/remove the container any time it's stopped (exited) for any reason - notice the --rm
docker run --name sqldev --rm -d -e ACCEPT_EULA=Y -e SA_PASSWORD=c0dingblocks! -p 1533:1433 mcr.microsoft.com/mssql/server:2017-latest-ubuntu

Run a container but keep it (and the internal state) around if it's only stopped and not removed - notice there is no longer a --rm
docker run --name sqldev -d -e ACCEPT_EULA=Y -e SA_PASSWORD=c0dingblocks! -p 1533:1433 mcr.microsoft.com/mssql/server:2017-latest-ubuntu

Run a container a map a volume to it so whatever happens in the container directory, you can see and access on your host
Even if you rm the container, the directory C:\Your\Directory\Here" will still contain the contents of the /var/opt/mssql/data folder from right before you killed the container
docker run --name sqldev -d -e ACCEPT_EULA=Y -e SA_PASSWORD=c0dingblocks! -p 1533:1433 -v "C:\Your\Directory\Here\:/var/opt/mssql/data/" mcr.microsoft.com/mssql/server:2017-latest-ubuntu

List all Docker containers currently not removed on your system
docker ps -a

Force stop and then also remove a container
docker rm -f sqldev

Launch the shell for the sql linux container that is running in the samples
docker exec -it -u root sqldev bash

Stop a running container
docker stop sqldev
OR
docker stop containerid

Start an exited / stopped container
docker start sqldev
OR
docker start containerid


Join us on Slack:
https://www.codingblocks.net/slack

Social
=============================================
Twitter: @CodingBlocks
Facebook: https://www.facebook.com/codingblocks

Podcast
===========================================
iTunes: https://www.codingblocks.net/itunes
Stitcher: https://www.codingblocks.net/stitcher