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 2005- Processing Backlogged Events taking a Long Time

I’ve had a lot of problems, but some of them are strange and can happen if certain default values are left on. Either they were enabled later for some reason and not restored, or they were skipped during the post-config check after SQL was installed.