Part III: SQL Server Integration Testing with Testcontainers
Add integration testing to your containerised SQL Server setup with Testcontainers for .NET. Spin up real SQL Server instances on-demand, run your tests, and tear them down automatically.
SQL Server
Easier Code Debugging with SQL Server Backups
Speed up your debugging workflow by restoring SQL Server backups to quickly reproduce issues. A practical guide to using BACKUP and RESTORE commands to reset your local database to a known state.
Part II: Initialising SQL Server with Docker Compose
Three ways to initialise a SQL Server container using Docker Compose: executing SQL scripts, using an mssql-tools container, and restoring from a bacpac.
Part I: Microsoft SQL Server with Docker Compose
A step-by-step guide to running Microsoft SQL Server in Docker Compose for local development. Covers configuration for both Windows and Mac (including ARM/Rosetta), health checks, persistent volumes, and team-friendly defaults.
SQL Server High Dpi Settings
A quick fix for SQL Server Management Studio looking awful on high DPI screens. Mostly a note to my future self.