Posts

Keep your dev loop as short as possible with SQL Server Backups

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.

Keep your dev loop as short as possible with SQL Server Snapshots

SQL Server snapshots let you quickly save and restore your local database state - handy when switching branches or debugging scenarios that need complex data setups.