Michael J. Swart explains why we can’t have nice things:
I spend a large amount of time translating software requirements into schema and queries. These requirements are sometimes easy to implement but are often difficult. I want to talk about UI design choices that lead to data access patterns that are awkward to implement using SQL Server.
Read on for three such examples, including sorting, paging, and search.