Always use UTF-8 collations to read UTF-8 text in serverless SQL pool

JovanPop: Having the same issue as gh_lausanne : The database XXXX could not be exclusively locked to perform the operation. Cannot use the standard ways to list open connections either. 

Solved it by listing active sessions and killing them manually. However there are some connections that seem to auto-reconnect, but by executing the statements in one batch instead of command by command it worked for me. 

SELECT [session_id] 
FROM [sys].[dm_exec_connections]

-- Make kill statements for each session_id

kill 83
kill 82
kill 80
kill 79
ALTER DATABASE xxxx
COLLATE Latin1_General_100_CI_AS_SC_UTF8;