A few weeks ago, we were discussing a problem with my team mates and a colleague raised a question about a very basic distributed remote caching problem which was about an application scaled out across multiple instances, managing how data is cached can become a significant challenge. Let me take the shortcut and directly jump into the problem. Consider a scenario where you have multiple instances doing the same job and you need to cache the result of a function which takes about 30 seconds. This function's result needs to be cached to avoid redundant executions across different instances. The…
MongoDB through C# – Using the Official Library
MongoDB is a popular NoSQL database, which means it doesn't use tables like traditional databases. Instead, it saves data as 'documents', which are like flexible data entries. If you're using C# and want to work with MongoDB, there's an official library made just for that. In this post, we'll check out this library, see some basic MongoDB info, and walk through some C# code examples for common tasks. In MongoDB, data is saved in collections as documents. Think of collections like folders on your computer, and documents like files in those folders. But here, each document can have different data…
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…