Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.

Blog

.NET and SQL Server curious cases

26.09.2022 / by Zsolt Soczó

Case study: making a query 25000 times faster – Part 3 (finishing touches)

We made a query 600 times faster in the first part. Then, we optimized it more in the second part, making it…

23.09.2022 / by Zsolt Soczó

Hunting orphaned files in a Visual Studio solution

The old project format of Visual Studio lists all files which logically belong to that project. The file system also contains a…

19.09.2022 / by Zsolt Soczó

Case study: making a query 25000 times faster – Part 2

In the previous article, I showed how to speed up a query by 600 times. In this part, I’ll demonstrate how we…

20.08.2022 / by Zsolt Soczó

Case study: making a query 25000 times faster – Part 1

One of my clients struggled with the following query: Sometimes it was fast, and sometimes it was slow. It seemed the query…

18.07.2022 / by Zsolt Soczó

The SQL Server, which thought it was a balloon – Part 2 – the root cause

In the previous part, I introduced a strange problem. A SQL Server occasionally used an excessive amount of memory, much more than…

09.07.2022 / by Zsolt Soczó

The SQL Server, which thought it was a balloon – Part 1

This was a very bizarre case. An SQL Server instance unpredictably and suddenly ate all memory of the server and even more…

28.06.2022 / by Zsolt Soczó

SQL Server blocking without a real reason?

My recent troubleshooting engagement was about a SQL server blocking problem. Imagine an insurance web application with large forms. The app automatically…

26.06.2022 / by Zsolt Soczó

Is compiling C# 10 code for .NET 4.7 possible?

I have asked this question today. Yes, it is possible. Here is the proof: As you see, I packed several C#9 and…

18.06.2022 / by Zsolt Soczó

SQL Server table compression options

I wrote about a build pipeline recently. It is a multi-job DevOps server pipeline that runs integration tests in parallel. I wrote…

07.06.2022 / by Zsolt Soczó

The mysterious 200ms delay

The issue described in this article was one of my most challenging cases. I solved it with my client in 2017. The…

02.06.2022 / by Zsolt Soczó

Where is the bug?

I just made an utterly silly logical error in this code. What is it? (This is not a performance question, this code…

26.05.2022 / by Zsolt Soczó

Optimizing a build pipeline

The topic of this blog entry is not a traditional code optimization where I make .NET code faster or tune SQL Server…

15.05.2022 / by Zsolt Soczó

SQL Server low Plan Cache hit ratio

This is a short story about a SQL Server troubleshooting job from 2014. The Plan Cache Hit Ratio was 60%. There was…

07.05.2022 / by Zsolt Soczó

Optimization Case Study: Pdf report generation

I have done many-many, very interesting .NET and SQL Server optimization work in the past 20 years. Actually, this is the most…

17.04.2022 / by Zsolt Soczó

EF Core HiLo sequence increment – it might not be what you have expected

It is not obvious, but when you use HiLo key generation strategy for EF Core, the increment of the underlying sequence should…

07.01.2022 / by Zsolt Soczó

A mégis mohó nem mohó regex

A normál regex quantifierek, mint a ?+* mohók, azaz, a lehető leghosszabb egyezést fogják meg. Azaz, a “cica kutya ló” bemenetre az…

25.11.2021 / by Zsolt Soczó

Windows Atom szivárgás nyomozása II.

Az első részben odáig jutottunk el, hogy valószínűleg egy RegisterWindowMessage API hívás helyezi el az Atomot a Windows Atom tárolójában. A google…

23.11.2021 / by Zsolt Soczó

Windows Atom szivárgás nyomozása I.

Egy nem hétköznapi hibát mutatok most be. Ez az első része a cikknek, a második itt olvasható. A managed memory leakeket elég…

07.07.2021 / by Zsolt Soczó

Architektúra dilemma

Tegyük fel hogy van egy klasszikus, többrétegű alkalmazásunk. Van benne egy service layer, ami hív valamiféle alkalmazás logikát. A logika direktben hivatkozik…

02.07.2021 / by Zsolt Soczó

Érdekes kép az SQL Server Query Store-ból

Itt a logical read-ek száma látszik, átlagolva. Mitől lehet ilyen érdekes a kép, mi történik a háttérben? Could you hire me? Contact…