SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

Developers often dispute the merits of SQL as a legitimate programming language, but this misses the point. SQL is a powerful 4GL for accessing data.

Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...