Tag: sql

SQL Server Pagination with COUNT(*) OVER() Window Function

January 30, 2026 · 5 min read
Stop running two queries for paginated results. Use COUNT(*) OVER() to get everything in one shot.

What is Dapper, and why you should consider it for your .NET projects

May 15, 2020 · 5 min read
I have a pretty firm opinion that if you're using a relational database with .NET, you need to have Dapper in your stack.