Understanding the Data Warehouse
What gave rise to the Data Warehouse? What do they enable? I answer these questions in this first of a two-blog series.
November 29, 2022
November 25, 2022
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.November 24, 2022
SQL or NoSQL? Why not use both (with PostgreSQL)?
How to turn Postgres into an easy-to-use NoSQL database that retains all the power of SQL
November 23, 2022
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.
A Programmer-Friendly I/O Abstraction Over io_uring and kqueue
This is an external post of mine. Click here if you are not redirected.
November 22, 2022
Flutter Authorization with RLS
Learn how you can secure your Flutter app using Supabase Row Level Security.
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
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.
November 18, 2022
PlanetScale and HIPAA
PlanetScale can now enter into Business Associate Agreements (BAA) with customers on an Enterprise plan.
The serverless revolution deserves more than just a serverless database
The serverless movement has eliminated so many problems but it has left application developers with the hardest one of all: managing distributed state.