sqldbawithabeard.com
Test the SQL Server database collation with PowerShell and dbatools
If your server collation is different to your database collation then you may find that you get an error similar to this Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS”…