Using WSL2 for the Database Development Platform
summary
Shows how to run Docker on WSL2 with SQL Server Linux containers (2017/2019), mounting persistent volumes and using bash scripts to copy backups, then restore a 2012 backup into a 2017 Linux container successfully. Demonstrates tooling: VS Code Remote - WSL, Docker extension, Azure CLI, Azure Data Studio and SSMS. Cites benchmarks where WSL2 improves ~3× over WSL1 and approaches bare-metal in some DB tests, and builds a repeatable backup‑transport and restore automation that works.
AI-written summary · about
chapters (19)
- 0:00Introduction
- 1:24WSL2 Features
- 4:35Benchmarks
- 9:13Configuration
- 16:06Docker
- 16:46Best Practices
- 19:31Tools
- 20:56docker configuration
- 24:41Visual Studio Code
- 27:06Docker Container
- 30:36Volume vs Mount
- 34:06View Container
- 37:46Refresh
- 38:26Verify
- 41:06Restore
- 42:16Query Inspect
- 42:41Query Log
- 44:36SQL Same Query
- 46:16Testing
related talks
41mDeveloping for Linux on Windows with WSL
01h 09mDeveloping for Linux on Windows
05mWindows Subsystem for Linux (WSL) Acquisition in Visual Studio
47mOptimizing the Microsoft developer experience with Docker
01h 03mVisual Studio Code and SQL Operations Studio
20mSQL Server 2022 migrations with dbatools
33mBecome a Docker Power User With Microsoft Visual Studio Code
44mNew developer experiences in Windows