Caching data is an important concept of successful projects. If your data does not change that much, cache it! Do not try to select same data repeatedly. There are many products can help you with caching. Usually, these products are not free, and you may need to learn a new language or technology to use them.
You can easily create powerful cache system by using JSON and In-Memory tables of SQL Server. Please join me as we create a NoSQL Cache solution by using only SQL Server.