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

Central Management Servers (CMS) is a built-in SQL Server feature that lets you manage multiple SQL Server instances from a single SSMS interface. The setup involves registering a hub server, adding managed instances, and optionally grouping them by environment. The key benefit is multi-server query execution: a single T-SQL query runs across all registered servers simultaneously, returning combined results with a server name column. Caveats include sequential (not parallel) execution, Windows Authentication working more smoothly than SQL logins, and read-only results in the multi-server grid.

Managing multiple SQL Server instances from SQL Server Management Studio