.NET and SQL Server curious cases
Random thoughts about Zanzibar islands and why a local guide is more valuable than you might have thought.TLDR: I wrote about my…
This is a short and non-scientific but exciting comparison of the two versions. I have a very CPU and Memory intensive financial…
Virtually all medium to large applications uses some Dependency Injection technology. I assume my readers know about it; I won’t repeat the…
Read the article, and I reveal the exact gain I made. :) This week I worked on two optimization tasks. They were…
You have learned that you have to think about exception handling cautiously. For example, do NOT catch too broad exception types like…
We made a query 600 times faster in the first part. Then, we optimized it more in the second part, making it…
The old project format of Visual Studio lists all files which logically belong to that project. The file system also contains a…
In the previous article, I showed how to speed up a query by 600 times. In this part, I’ll demonstrate how we…
One of my clients struggled with the following query: Sometimes it was fast, and sometimes it was slow. It seemed the query…
In the previous part, I introduced a strange problem. A SQL Server occasionally used an excessive amount of memory, much more than…
This was a very bizarre case. An SQL Server instance unpredictably and suddenly ate all memory of the server and even more…
My recent troubleshooting engagement was about a SQL server blocking problem. Imagine an insurance web application with large forms. The app automatically…
I have asked this question today. Yes, it is possible. Here is the proof: As you see, I packed several C#9 and…
I wrote about a build pipeline recently. It is a multi-job DevOps server pipeline that runs integration tests in parallel. I wrote…
The issue described in this article was one of my most challenging cases. I solved it with my client in 2017. The…
I just made an utterly silly logical error in this code. What is it? (This is not a performance question, this code…
The topic of this blog entry is not a traditional code optimization where I make .NET code faster or tune SQL Server…
This is a short story about a SQL Server troubleshooting job from 2014. The Plan Cache Hit Ratio was 60%. There was…
I have done many-many, very interesting .NET and SQL Server optimization work in the past 20 years. Actually, this is the most…
It is not obvious, but when you use HiLo key generation strategy for EF Core, the increment of the underlying sequence should…