Pedro Lopes
aka.ms/sqlserverteam
Pedro Lopes is a Principal Program Manager in the Azure Data SQL Server team, focusing on the Relational Engine for SQL Server and Azure SQL (Query Processor, Query Performance, Programmability).
SQLBits 2020
Storing strings in SQL Server and Azure SQL DB
in this session you will learn about what Unicode encoding you want to use for your scenario, what are the performance differences, and even debunk a few SQL Server myths along the way.
As businesses and applications reach global scale, you know that SQL Server and Azure SQL can support international applications using Unicode. And you’ve been working with SQL Server for long, so handling and storing strings is not a mystery. Or is it? It depends – it’s all about knowing what’s there, and making informed choices when you design the database.SQL Server 2019 and Azure SQL introduce support for UTF-8 and with that, deliver on a decade old request – in this session you will learn about what Unicode encoding you want to use for your scenario, what are the performance differences, and even debunk a few SQL Server myths along the way.