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.
Erland Sommarskog has submitted 4 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

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.
In this session we will learn why loops are slow and why set-based statements are faster. But we will also learn that there are occasional situations when you need to loop and why a cursor may be a best choice in that case.
You know that set-based statements is the way to work. However, there are situations when trying to process all data in one go becomes too much and you should break up the operation in batches. In this session we will look at techniques to do this.
This is a session about error handling in SQL Server where you will learn how to differently SQL Server reacts on seemingly different errors how you should implement your error handling to cope with this.

Sessions

Previous Sessions

This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
Erland_Sommarskog.jpg