SQL Server

Using SQL server backups to enhance debugging workflows in your development process.

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.

Unlock the power of containerised development environments with this guide to setting up Microsoft SQL server using Docker Compose. Whether you’re a solo developer or part of a team, learn how to leverage Docker Compose for SQL server.

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’s 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.

Discover the power of SQL Server Snapshots for managing database versions, simplifying testing, and enhancing debugging workflows in your development process. This guide explores how snapshots can mitigate the challenges of switching branches and setting up complex data scenarios, offering a faster, more reliable method for restoring databases to a known state. Learn to effortlessly navigate database changes with snapshots, keeping your local environment aligned with your development needs.