Most developers are used to using relational databases and most of them will use them without considering alternatives. This will work in most cases, but sometimes using something different might help you to solve your problem faster. MongoDB is one of most popular NoSQL databases, and it might make your life/job easier too.

Parameter sniffing is a great feature of SQL Server that helps execute queries with less CPU and memory consumption, but sometimes can go bad on us. Meaning our queries can take longer execution times, use more IO and CPU. Why does this happen and how to deal with it I will describe in this blog post.