When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

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 ...

When it comes to assigning value to different components in today’s IT environment, it would be a serious mistake to underestimate the value of data and databases. Whether you are looking to reduce ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if indexed ...

SQL Server 2025 shifts optimisation from a reactive activity to an intelligence-driven discipline. Built-in intelligence is embedded directly into the platform, reducing reliance on external tooling.

Latest service pack comes more than a year after the last service pack, and also adds a number of enhanced monitoring capabilities. It's been a long time coming -- nearly a year and a half since ...

If you’re a database admin, you might want to be able to keep track of the performance of those servers. Jack Wallen shows you how with Percona and Docker. One responsibility of database ...