Death to SQL Server! Long live SQL Server! How containerized SQL Server makes development easier

Managing development databases can be tricky, especially if members of the team want to develop on a Mac or Linux device. Besides being bulky, installing SQL Server Express or Developer Edition can open needless attack vectors on your local machine. In this presentation, we learn how running SQL Server in Docker containers can help ensure a consistent development & testing experience for the entire team.

Transcript

1. www.dotnetconf.net
3. New talk. Who dis?
5. Docker?!? We don’t need no stinking dockers.
7. Nobody puts SQL in a container* *Dirty Databasing
8. *Dirty Databasing starring Sean Hasselhoff
10. docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=DOTnetConf2019!' --name sql1 -d mcr.microsoft.com/mssql/server:2017-latest
11. docker cp ClientGonnaClient.bak sql1:/var/opt/mssql/data/ClientGonnaClient.bak {container id/name} {path}
12. docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=DOTnetConf2019!' --name sql1 -p 1433:1433 -v D:/Sources/data:/var/opt/mssql/data -d mcr.microsoft.com/mssql/server:2017-latest p 1433:1433 • -v D:/Sources/data:/var/opt/mssql/data Formatted as: {host path} {container path}