22-25 April 2026
Book Now

Erland Sommarskog

sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm. He has worked with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and he has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

Erland Sommarskog's Sessions

Analysing and Resolving Deadlocks.SQLBits 2024

Learn how get information about the deadlock XML, how to read it, what actions you can take to prevent deadlocks or at least mitigate the consequences of them. The session also includes a recap on locking in SQL Server.

Ask the Expert - Group A (Thu 14:10 to 15:00)SQLBits 2024

Come and see to some of our amazing speakers on one of these topics: 1. SQL and Databases: 2. Microsoft Fabric and Related Technologies: 3. Power BI and Data Visualization: 4. Azure and Cloud Technologies:

Don’t Let Your Permissions Be Hijacked!SQLBits 2023

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.

Don't Bite Off More than You Can Chew - Take it in ChunksSQLBits 2022

How you can improve performance by splitting up large operations in chunks

Packaging Permissions in Stored ProceduresSQLBits 2019

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.

Dynamic Search ConditionsSQLBits 2016

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

Analysing and Resolving Deadlocks.SQLBits 2024

Learn how get information about the deadlock XML, how to read it, what actions you can take to prevent deadlocks or at least mitigate the consequences of them. The session also includes a recap on locking in SQL Server.

Ask the Expert - Group A (Thu 14:10 to 15:00)SQLBits 2024

Come and see to some of our amazing speakers on one of these topics: 1. SQL and Databases: 2. Microsoft Fabric and Related Technologies: 3. Power BI and Data Visualization: 4. Azure and Cloud Technologies: