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