• Programming Languages - Coding - C# - Advanced - Software Engineering

    Advanced C# Tips: Don’t Use unsafe for Minor Gains

    The title could have also been “Don’t use unsafe code at all!” You will come to the same conclusion after reading this post, but still I gave a room for its usage. In C#, the usage of unsafe code is a topic of debate. On one side, it offers the potential for performance gains in specific scenarios. Yet the risks and complexities it introduces often outweigh its benefits. What is unsafe Unsafe code in C# refers to a block of code that uses pointers and allows direct memory manipulation, bypassing the .NET runtime’s type safety and security checks. This capability…

  • Databases - Intermediate

    SQL Server Performance Tips for High Volume Databases

    As businesses grow, so does their data. A big amount of data can slow down your SQL Server if you don’t manage it right. This article shares some top tips to speed up your SQL Server when dealing with a lot of data. On the other hand, before we jump into the tips, it’s important to know there’s no magic button that fixes everything. Each problem is unique. While the tips I’ve given here can help many setups, they might not work for everyone. Simply applying fixes without understanding can cause more issues. It’s really important to first figure out…