Updating SQL Server Instance Collation without rebuilding Master Database

Whether a SQL Server DBA is a newbie or an experienced, rebuilding the master database is one of the most dreaded tasks.

It’s similar to the fear of walking into the unknown without knowing what’s on the other side of the road.

SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1

Pinal Dave’s  blog has been one of my go-to blogs as a SQL DBA for a long time.