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.
SQLDW introduced support for over 3800 collations a while ago. I am therefore now marking this suggestion as completed. Please excuse the tardy response to your feedback.
Please refer to the following post for more information:
Thanks for the feedback!