Sample SQL Server Database and Docker

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:

Some helpful notes from the video:
Contoso Sample BI Database Download

Run a container and kill/remove the container any time it's stopped (exited) for any reason - notice the --rm

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

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

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:

Social
=============================================
Twitter: @CodingBlocks

Podcast
===========================================

[shiretsu]

you're good at this! this style of presentation is easy to follow, engaging, enriched by insight as you go. much better than being lectured at.

[andycoffman]

Great video. New versions of SSMS get real pissy when services are stopped behind its back.

[saimakmal]

Great video for starters. Will you post similar video for oracle database to import database?