Erland Sommarskog's home page

I'm an independent consultant who provides expert consulting in the SQL Server area. I was awarded Most Valuable Professional on SQL Server by Microsoft in April 2001. This page gathers articles and utilities that I have written about and for SQL Server. Details on my consulting business are available here in Swedish and here in English. The English page includes some information about me as a person. I also have a photo gallery (which has very little relation to SQL Server...)

To see what has changed on this site recently, please see my web log.

Have you attended any of my talks? Go here to download slides and scripts. On this page you also can view my upcoming speaking engagements.

"A Small Collection of Large Articles"

Through the years I have written a number of in-depth articles about specific topics related to SQL Server, mainly from a development perspective. I try to keep the articles up-to-date, and I more than welcome feedback, both about contents and spelling/grammar errors!

SQL Short Stories

This is a new section that I eventually will have a separate page for. The intention is that this will be a collection of shorter texts for tips in a specific area.

My SQL Server Wishlist

I've compiled a list of Uservoice items related to development that I wish to see implemented in SQL Server, the sooner the better. Read it and vote for the suggestions you like! Latest revision: 2019-04-27.

Utilities and Code

All of this is code in the public domain.


You can reach me on