Sql

EF core 7.0 introduces a new, more efficient way of upating one or more properties of several entities.

Window functions allow you to answer interesting questions about your data. In this post we are going to look at the RANK and DENSE_RANK functions in particular.

I think of a drill as a small exercise you do every now and then to keep yourself sharp. This drill is about using pivot in SQL.