Summing a BIT column with a numeric as the outcome

A Version Control Strategy for Branch-based Database Development

The migration to a different VCS should not be underestimated, as there is a lot more involved than just switching tools, and that’s what Tonie Huizer covers in this article.
First, the team needed to migrate the monolithic repos over to Git, second the team needed to make sure we had a branching strategy and workflow in place.
It involved a big process change for the team as well, but this switch is mandatory to make full use of branch-based database development.

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

A look back at the PASS Data Community Summit in 8 slides from Tonie Huizer.

DIY Database Clones

This article explores the 'shadow copy' and 'disk virtualization' services built into the Windows operating system and explains a basic solution demonstrating how the technology is used to copy the data and log files for a live SQL Server database into an 'image', from which we can create multiple, lightweight copies, or clones, of the original database.