Yugabyte announced it is releasing YugabyteDB 2026.1 with enhanced AI capabilities along with YugabyteDB AMP (Agentic Multitenant PostgreSQL) for true serverless, scale-to-zero PostgreSQL where every ...

Analyzing Oracle execution plans is a core skill for database professionals aiming to optimize SQL performance. Execution plans reveal how Oracle retrieves data—whether it uses indexes, full table ...

postgresql-unit implements a PostgreSQL datatype for SI units, plus byte. The eight base units can be combined to arbitrarily complex derived units using operators defined in the PostgreSQL type ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Implementing Bloom filters in Azure SQL, or any SQL Server environment, is an advanced technique that leverages the concept of Bloom filters for efficient querying, especially when dealing with large ...

本文重点尝试从ODPS SQL的逻辑执行计划和Logview中的执行计划出发，分析日常数据研发过程中各种优化方法背后的原理，覆盖了部分调优方法的分析，从知道怎么优化，到为什么这样优化，以及还能怎样优化。 一、背景 使用ODPS SQL进行离线数据研发时，开发同学不 ...

Our previous blog article, “The Part of PostgreSQL We Hate the Most,” discussed the problems caused by everyone’s favorite street-strength DBMS multi-version concurrency control (MVCC) implementation.

The new ledger feature in SQL Server 2022 provides blockchain-based security to ensure data isn't tampered with. The ability to cryptographically guarantee the integrity of data is especially useful ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

In Dynamics 365 2020 release wave 2, the hash function for the dimension framework in Dynamics 365 Finance has changed. This change may cause breaks in your production and test code in some scenarios.