Production performance problems arrive with pressure. Users are waiting. Jobs are queued. Management wants answers in five minutes. The fastest-looking response — jumping straight to a query plan, ...

A query using a nonclustered index is not always efficient. In many SQL Server workloads, the optimizer performs an Index Seek followed by a Key Lookup to retrieve columns not available in the ...

This paper demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the ...

Attila covers software, apps and services, with a focus on virtual private networks. He's an advocate for digital privacy and has been quoted in online publications like Computer Weekly, The Guardian, ...