I want for my application the same collation at all database levels (server, database, columns): Latin1_General_CI_AS This is recommanded by Dan Guzman to have constistent collations and get the collation configuration right from the start.
The default collation for a Azure SQL Server (server) is SQL_Latin1_General_CP1_CI_AS. I would like to change this to Latin1_General_CI_AS. Or create a new Azure Sql Server (server) with the collation Latin1_General_CI_AS. For on premise SQL Servers it is possible.
In the SQL Azure Collation Documentation from 2010 is stated that ...the server and database collations cannot be configured in SQL Azure... Besides this, I didn't found something useful.
I would be totally happy if I could create a new Azure SQL Server (server) with a collation Latin1_General_CI_AS.
Is it somehow possible or exists a workaround? I really appreciate any help.