Erland Sommarskog is an independent consultant from Stockholm. He has been working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has held the award since. His passion is systems development with SQL Server, the core database engine.


This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
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.