BartWullems's blog is a platform for sharing insights and expertise in Microsoft technologies, software development best practices, and programming tutorials. Through articles, code samples, and technical discussions, BartWullems offers insights into building scalable, maintainable, and performant software applications using Microsoft technologies such as .NET, Azure, and Visual Studio. Readers can learn about design patterns, development techniques, and tooling recommendations to enhance their skills and productivity as Microsoft developers. Additionally, BartWullems provides updates on the latest developments in Microsoft ecosystem, community events, and industry trends to help developers stay informed and engaged in the Microsoft developer community.

The Art of Simplicity

SQL Server silently renames a database user to match the login name when you run ALTER USER ... WITH LOGIN without specifying a NAME. This breaks idempotent scripts: the first run renames the user, the second run can't find it and fails. The fix is to explicitly include WITH NAME = [original_username] in the ALTER USER statement to preserve the username while remapping the login.

SQL Server silently renames your user when you ALTER with a login