a curated list of database news from authoritative sources

November 25, 2022

Michael J. Swart - Database Whisperer

Use RCSI to tackle most locking and blocking issues in SQL Server

What’s the best way to avoid most blocking issues in SQL Server? Turn on Read Committed Snapshot Isolation (RCSI). That’s it. Configuring RCS isolation level To see if it’s enabled on your database, use the is_read_committed_snapshot_on column in sys.databases like this: select is_read_committed_snapshot_on from sys.databases where database_id = db_id(); To enable the setting alter the […]

The post Use RCSI to tackle most locking and blocking issues in SQL Server first appeared on Michael J. Swart.
by Michael J. Swart

November 24, 2022

November 23, 2022

Stack - Convex Blog

Jamstack Conf 2022 Panel: The Future of Databases

Today, a new wave of innovation is making databases approachable for developers without requiring a specialized skillset, opening the door to a whole new category of ambitious web experiences. In this panel, you’ll hear from the people pushing the boundaries of database technology and learn what’s possible — and what’s coming.

November 22, 2022

Vitess Blog

Introducing VDiff V2

Vitess is a solution that allows you to infinitely scale MySQL while providing clients and apps with a single logical view of the fleet of MySQL instances comprising any number of Keyspaces and Shards. Vitess also provides the cluster and data management tools that make it possible to manage a massive cluster and perform complex workflows using VReplication, such as: Moving tables into Vitess or between keyspaces Resharding to adjust to changes in data size and load Materialized views and rollups for data analytics and data locality Online schema changes that are trackable, cancellable, revertible, and retryable Why a Diff Tool?

November 20, 2022

Hack MySQL

MySQL IOPS for Reads and Surprsies

When you think about IOPS, you probably think about writes because MySQL write I/O has a long tradition of optimization, benchmarking, new algorithms, new storage engines, and so forth. There’s no shortage of material on MySQL write I/O; just two examples from Percona are Scaling IO-Bound Workloads for MySQL in the Cloud and Tuning MySQL/InnoDB Flushing for a Write-Intensive Workload. But in this short blog post I highlight two other, less common aspects of MySQL I/O: reads and surprises.

by Daniel Nichter

November 18, 2022

PlanetScale Blog

PlanetScale and HIPAA

PlanetScale can now enter into Business Associate Agreements (BAA) with customers on an Enterprise plan.

November 17, 2022