This page gives some information about my consulting services, my résumé in summary and in detail. At the end there is some information about my life beyond SQL Server.
Erland Sommarskog SQL-Konsult AB has exactly one employed: me. And, no, there are no plans for expansion.
I started this company when I left my old job at the end of 2007. My idea is to provide expert consulting around SQL Server. That could consist of actively taking part in a project at clients, but I also hope that a lot will be about mentoring. That is, rather than develop solutions for clients, I want to give them advice how to implement their solutions and review their designs. I also expect to be brought in when clients have urgent performance problems to tune queries.
SQL Server is a very broad product, and I would commit a gross lie if I said that I knew it all. My expertise lies with the Database Engine and the tools and my focus is on systems development and design. Things that I feel very confident with are:
As for pure DBA duties, I have never had such a position, but I've learnt a good deal in my work, as well as from my MVP colleagues, and I would definitely enjoy such a gig. I have no experience of the BI side of SQL Server.
Technical knowledge outside SQL Server: My best language outside SQL Server is Perl. Recently, I'm trying to pick up Powershell and Python, adn I can write C# and C++ left-handedly. Since I have worked extensively with system development also without databases, I feel that I can contribute to discussions about system design in general, even if my knowledge of .NET in general is shallow.
Geography: As I live in Stockholm, this is where I expect to have most of my clients. But I like travelling, and I don't mind working with customers elsewhere.
Availability: The problem with being a one-man band, is that there is a short distance between having too much work and having too little. For 2021 I expect to be engaged with one client for about 80 %. If you want me for some mentoring or performance-tuning job, I may be able to find the time, so you are welcome to get in touch.
Up to 2017, I mainly worked for Tieto, who had acquired the company I worked with before that. In 2018, I split my time between Tieto and Peab (a construction company), and since 2019 Peab is my main client. All through the years, I have a few short advisory and performance-tuning gigs with other customers, of which several have engaged more than once.
Tieto, a major Finnish-Swedish IT corporation acquired Abaris, the company where I had worked for in eleven years, in the beginning of 2007. Abaris itself was a small company. We were 25 when I joined in 1996 and we peaked at 120 in 2001. At the time Tieto acquired the company we were around 85 persons in Stockholm, Gävle, Helsinki and Oslo.
The main achievement of Abaris is AbaSec, a very broad system for securities trading: placing orders, gateways to external systems, back-office for settlement and custody, asset management, fund management, pension-savings and more. Today, AbaSec is a prominent part in Tieto's portfolio for capital-market solutions and it's the leading product of its kind on the Nordic market.
My main task at Abaris/Tieto was being responsible for the database for the back-office system, which is the core component of AbaSec. More in detail, this means:
This may seem very broad to you, but this is the charm with working in a small company: you become a jack-of-all-trades almost by necessity.
ENEA is a consultant company, which in practice means that I changed jobs every once in while, without changing employers. Here is what I did during my ten years at ENEA:
|1985||Supplemental system start functions in a real-time system, programming and testing. Target: Motorola 68000 Development: VAX/VMS. Language: Pascal.|
|1985-1987||Development of general graphics module for real-time radar systems. Design, programming and testing. Target: AMD2901, Development VAX/VMS. Language: Pascal.|
|1988-1990||Back-office system for securities trading. (No, not at Abaris, but the people I worked with would later start Abaris.) Programming, design of generic routines and CM tools. Environment: VAX/VMS, DEC/Rdb, Pascal, Cobol and various Digital tools.|
|1991||Configuration Management tools for a military naval system. Environment: VAX/VMS, DEC/Rdb, Ada and Cobol.|
|1991-1992||Development in-house at ENEA of two medical systems, one for pathology labs and one system for administrating checkups for cervix cancer. I was responsible for testing and was sub-project leader for testing, CM and installation. Environment: Unix, Sybase, APT, shell scripts, Perl and C.|
|1992-1993||Development of CM tools, both for external and internal use. Unix, Perl and RCS.|
|1993-1995||Continued support and further development of the two medical systems, particularly the one for cervix cancer. Functional design, database design, programming, testing, installation, system administration. Environment: see above.|
|1994-1995||System for a database of trucks on CD. My task was to implement communication to external systems. Environment: Win3.1, Visual C++, TCP/IP, Unix, C.|
I worked extra as a student teacher in Programming and Mathematical Statistics. During this period I was exposed to Fortran, Pascal, assembler and Simula.
Beside my engineering classes, I also had one semester of practical philosophy.
I was named SQL Server MVP in April 2001.
I had two articles published in SQL Server Professional, the issues of January and August 2000. (And if you wonder why I have not published any articles since, the answer is simple: I prefer to write for my own web site where I can update the article as new information comes in.)During my period at ENEA, I also did minor work with Ada and Eiffel. I was a member of a Swedish reference group for Ada 95, and participated in one international conference on Ada 9x.
Back to my home page.