Elevator Pitch
Managing development databases can be tricky, especially if members of the team want to develop on a Mac or Linux device. In this presentation, we learn how running SQL Server in Docker containers can help ensure a consistent development & testing experience for the entire team.
Description
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.
Notes
Topics covered:
- What is Docker
- Benefits of running containerized SQL Server versus local SQL Server installs
- How to run SQL Server in a container
- Using SQL Management Studio to connect to containerized SQL Server
- Sharing host directories with a container for persisting data
- Using Dockerfiles to create consistent development environments