It's just SQL: Collations in Azure SQL Database Managed Instance | Data Exposed
Channel 9
English - January 02, 2020 20:27 - 4 minutes - 3.85 MB - ★★★★ - 38 ratingsTechnology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
You're probably familiar with Collations in SQL Server, but how do Collations change in Azure SQL Database Managed Instance?
In this video, Anna Thomas and Colin Murphy cover a brief overview of collations (https://docs.microsoft.com/en-us/sql/t-sql/statements/collations) and how they're different in Azure SQL Database Managed Instance.
[00:00] - Introduction[00:29] - What is a collation?[00:55] - Checking current collation in T-SQL and Azure Portal[02:13] - How many collations are there and listing the available collations in T-SQL[02:41] - Specifying a collation[03:24] - Usecase for collations[03:46] - Wrap-up