I've been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to the data tier. Writing the ...

Google is encouraging its database developers to lean "heavily" on AI coding tools as it ramps up contributions to open source projects such as PostgreSQL. Earlier this year, Google announced a raft ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

The system-to-administrator ratio is commonly used as a rough metric to understand administrative costs in high-scale services. With smaller, less automated services this ratio can be as low as 2:1, ...

This article describes troubleshooting steps that might help resolve problems that occur after the Replication Log Reader Agent fails in SQL Server. When the ...

Linked servers rely on network communication, which can introduce significant latency, especially for high-traffic queries or operations involving large datasets. Distributed queries through linked ...

Get up and running—and avoid the setup pitfalls—with this enterprise-class, open-source database available for all major platforms. For years now, PostgreSQL has been one of the best-kept secrets of ...

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects simply to a non-technical, business audience. Over… DBMSs are important ...

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...