22-25 April 2026 
Looping Abreast
2022TL; DR
How to combine loops and set-based statements for difficult problems.
Session Details
There are problems that are difficult to express entirely set-based with set-based code and we have to resort to loops. Say that we need to make such a computation for every customer. Does this mean that we must also loop over the customers? No, in this short presentation I will discuss how we can combine set-based and loops for best performance.
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.