More Collation support + ability to set via the Portal
Right now according to the documentation the only options for collation on SQL Data Warehouse are "The default collation is SQL_Latin1_General_CP1_CI_AS. The other collation option is Latin1_General_100_CI_AS_KS_WS."
We run Latin1_General_CI_AS which I suspect a large amount of UK customers would do. This is a supported Collation as per SQL Azure which we are migrating our operational datastore to but we can't move our data warehouse because of this. Also like SQL Azure can we have this as an option via the management portal when we create a DW.
Thanks for the suggestion. We have added more collation support via CREATE DATABASE. The option to select additional collations through the portal is yet to come. The CREATE DATABASE MSDN doc has been updated to reflect this new feature. See https://msdn.microsoft.com/en-us/library/mt204021.aspx. 6234007