Dirty reads happening in RCSI in Azure SQL Server

Although my database isolation level is set to READ_COMMITTED_SNAPSHOT, I am still getting dirty (uncommited) reads.

SELECT COUNT([random_string]) NoTx FROM [dbo].[IncTesting5];
BEGIN TRANSACTION;
    INSERT INTO [IncTesting5] ([random_string]) VALUES ('UncommittedRow1'),('UncommittedRow2');
    SELECT COUNT([random_string]) NoHint FROM [dbo].[IncTesting5];
    SELECT COUNT([random_string]) WIthHint FROM [dbo].[IncTesting5] WITH (READUNCOMMITTED);
ROLLBACK TRANSACTION;

This query returns NoTx = 0, NoHint = 2, WIthHint =2. I would expect NoHint to equal 0.

query showing weird behaviour

Read more here: Source link