Often, designing databases and speeding up SQL Server queries are treated as a kind of abstract problem: A just "Find this problem, apply this solution" approach to problem solving. In practice, ...

Perhaps a bit of an esoteric problem but... I have a SQL Server 2008 instance on EC2 (running on 2008 R2) under heavy load. I'm trying to optimize I/O performance and after a couple iterations I'm ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

In a modern enterprise data environment, the increasing volume of data, distributed architecture, and complex application dependencies challenge traditional query-tuning methods. Observability ...

Forge 2025.3 adds AI Assistant to SQL Complete, supports SSMS 22, Visual Studio 2026, MySQL 9.5, MariaDB 12.2, and ...