UKRAINE. Kiev. 2019. Kiev Children's Railway. Museum

Fun and profit with UTF-8

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available in Azure SQL Database, UTF-8 is exciting if you have a legacy database and application that needs to support Unicode strings for globalization, but you can’t afford to double the storage requirement by converting all your CHAR and VARCHAR columns to
-> Continue reading Fun and profit with UTF-8

Post image

So, like, what is a byte?

A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before, was reading through the first five posts of this Database Fundamentals series, and asked a great question: “I guess I’m not understanding what a byte is. I think I’m circling the drain in understanding it, but not
-> Continue reading So, like, what is a byte?