Change the Instance Collation by Rebuilding Databases in SQL Server 2017


As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations for handling different languages. Now I may have a habit of hitting the Next button when I am on the collation page, simply ignoring it.

Recently, however,  I had a requirement from one application team to have a different collation. As usual, I ignored the