22-25 April 2026 
Collations and Performance
2022TL; DR
When collation affects performance a lot - and when hardtly at all
Session Details
You might have asked yourself: What effect does my choice of collation have performance? In this session I will cover two situations where the collation has a dramatic impact on performance. I will also discuss the impact in more general cases, based on data from performance tests I have run.
3 things you'll get out of this session
Speakers
Erland Sommarskog's previous sessions
Don’t Let Your Permissions Be Hijacked!
Learn how malicious users can lure a power user such as sysadmin to run code that performs action to the benefit of the evil user by something I call permission hijacking and what means you can take to prevent this from happening.
Packaging Permissions in Stored Procedures
Learn in this session how you can package any database- or server-level permission in a stored procedure with help of certificate signing or EXECUTE AS and why one method is to prefer over the other.