Episode

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

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