SQL Server Integration Testing with Testcontainers

Part III: SQL Server Integration Testing with Testcontainers

Take your containerised SQL Server setup to the next level by using Testcontainers for .NET to write robust integration tests. Spin up real SQL Server instances on-demand, run your tests, and tear them down automatically.

January 7, 2026 路 16 min 路 3351 words 路 Paul McIlreavy
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.

April 21, 2024 路 3 min 路 516 words 路 Paul McIlreavy
Initialising SQL Server with Docker Compose

Part II: Initialising SQL Server with Docker Compose

This article explores three effective methods for initialising a SQL Server container using Docker Compose: execution of SQL scripts, leveraging mssql-tools, and restoring from a bacpac.

April 6, 2024 路 10 min 路 1926 words 路 Paul McIlreavy
Microsoft SQL Server with Docker Compose

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.

April 5, 2024 路 11 min 路 2221 words 路 Paul McIlreavy
SQL Server High Dpi Settings

SQL Server High Dpi Settings

Overcome the challenge of distorted displays in SQL Server Management Studio on high DPI screens with this effective fix. This guide provides a straightforward solution to the common scaling issues encountered on 4K monitors, ensuring a crisp and clear SSMS interface. Whether it鈥檚 disappearing buttons or weirdly scaled menus and dialogs, learn how to adjust compatibility settings and use a custom manifest file to optimize SSMS for your high-resolution display. Perfect for developers and database administrators seeking an enhanced SQL management experience.

January 3, 2021 路 2 min 路 416 words 路 Paul McIlreavy