It's just SQL: Collations in Azure SQL Database Managed Instance | Data Exposed


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



Source link