The Wonderful World of Collations, Encodings and Text Storage

Explore the intricate world of character handling, collations, encodings, sort orders, diacritics, and code pages in this 45-minute conference talk from SQLBits. Delve into the complexities of text storage and processing, gaining a comprehensive understanding of how these elements interconnect. Learn from Mladen Prajdic, a Data Platform MVP and experienced C# and SQL Server developer, as he breaks down these often confusing concepts. Discover practical insights applicable to Azure, database engine operations, administration, development, modeling, and optimization for both on-premises and cloud environments. Enhance your skills in handling text-related challenges in SQL Server and broaden your knowledge of database management intricacies.