22-25 April 2026 
Dynamic Search Conditions
2016TL; DR
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
Session Details
A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that isboth maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
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.