How We Handled a Vendor Retry That Loaded Twice in Snowflake
The vendor file arrived twice overnight, Snowflake loaded both copies without complaining, and finance found the problem before the pipeline did.
2026-07-01
1,018 reads
The vendor file arrived twice overnight, Snowflake loaded both copies without complaining, and finance found the problem before the pipeline did.
2026-07-01
1,018 reads
Learn about transaction ID wraparound in PostgreSQL, which caused a problem for the author.
2026-02-23 (first published: 2026-02-13)
5,363 reads
Learn how backup and restore work in Azure SQL Hyperscale in this next level in the stairway series.
2025-12-17
1,039 reads
In this level, we learn about the database file size growth in Hyperscale.
2025-12-03
222 reads
Learn about filtered indexes in SQL Server, how they work, and how they can help improve performance.
2025-11-24
5,576 reads
Learn about unlogged tables and how they work in PostgreSQL.
2025-11-21
5,852 reads
Learn about a MySQL feature that could be useful in some scenarios for SQL Server.
2025-11-10
4,491 reads
Learn about how the Log Service helps manage transactions in the Hyperscale Tier.
2025-10-29
1,178 reads
Learn about implicit transaction and why you might not want to enable this setting.
2025-10-24
7,080 reads
In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.
2025-10-08
572 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers