Choices, choices: Using Unicode in SQL Server and Azure SQL Database

%3CLINGO-SUB%20id%3D%22lingo-sub-942169%22%20slang%3D%22en-US%22%3ERe%3A%20Choices%2C%20choices%3A%20Using%20Unicode%20in%20SQL%20Server%20and%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-942169%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20everyone%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fstareyes_40x40.gif%22%20alt%3D%22%3Astareyes%3A%22%20title%3D%22%3Astareyes%3A%22%20%2F%3E%3C%2FP%3E%0A%3CP%3EMy%20name%20is%20Ronen%20Ariely%20and%20I%20am%20the%20speaker%20in%20this%20session.%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20any%20question%20before%2C%20during%2C%20and%20after%20the%20session%20then%20you%20are%20welcome%20to%20contact%20me%20on%20Facebook%20or%20Linkedin.%20In%20addition%2C%20I%20will%20be%20available%20during%20the%20event%20or%20after.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B-%26nbsp%3B%3CSPAN%3ERonen%20Ariely%3C%2FSPAN%3E%3CBR%20%2F%3E%26nbsp%3B%5B%3CA%20href%3D%22http%3A%2F%2Fariely.info%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPersonal%20Site%3C%2FA%3E%5D%20%5B%3CA%20href%3D%22http%3A%2F%2Fariely.info%2FBlog%2Ftabid%2F83%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EBlog%3C%2FA%3E%5D%20%5B%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fronen.ariely%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFacebook%3C%2FA%3E%5D%20%5B%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fpitoach%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELinkedin%3C%2FA%3E%5D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72277%22%20target%3D%22_blank%22%3E%40Microsoft%20Ignite%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887529%22%20slang%3D%22en-US%22%3EChoices%2C%20choices%3A%20Using%20Unicode%20in%20SQL%20Server%20and%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887529%22%20slang%3D%22en-US%22%3EAs%20businesses%20and%20applications%20reach%20global%20scale%2C%20you%20know%20that%20SQL%20Server%20and%20Azure%20SQL%20Database%20can%20support%20international%20applications%20using%20Unicode.%20And%20you%E2%80%99ve%20been%20working%20with%20SQL%20Server%20for%20long%2C%20so%20handling%20and%20storing%20strings%20is%20not%20a%20mystery.%20Or%20is%20it%3F%20It%20depends%20%E2%80%93%20it%E2%80%99s%20all%20about%20knowing%20what%E2%80%99s%20there%2C%20and%20making%20informed%20choices%20when%20you%20design%20the%20database.%20SQL%20Server%202019%20and%20Azure%20SQL%20Database%20introduce%20support%20for%20UTF-8%20and%20with%20that%2C%20deliver%20on%20a%20decade%20old%20request%20%E2%80%93%20in%20this%20session%2C%20learn%20about%20what%20Unicode%20encoding%20you%20want%20to%20use%20for%20your%20scenario%2C%20what%20are%20the%20performance%20differences%2C%20and%20even%20debunk%20a%20few%20SQL%20Server%20myths%20along%20the%20way.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-887529%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ETHR3143%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Community Manager
As businesses and applications reach global scale, you know that SQL Server and Azure SQL Database 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 Database introduce support for UTF-8 and with that, deliver on a decade old request – in this session, 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.
1 Reply
Highlighted

Good day everyone:stareyes:

My name is Ronen Ariely and I am the speaker in this session.

If you have any question before, during, and after the session then you are welcome to contact me on Facebook or Linkedin. In addition, I will be available during the event or after.

 

 - Ronen Ariely
 [Personal Site] [Blog] [Facebook] [Linkedin]

 

 

@Microsoft Ignite 

View this session in the session catalog

View session