Investigate Slow SQL Queries and How to Potentially Workaround Them

We recently had an issue with a null insert into a non-nullable column in some huge table on a production Azure SQL Server Hyperscale database. Failure happend on 'Sink' side. ErrorCode=SqlOperationFailed, 'Type=Microsoft.DataTransfer.Common.Shared....