I've been doing some testing with Dynamic Data Masking to try and find out if/how it works.   To do that, I'm running a script that works perfectly fine in SQL Server and Azure SQL Server. But it fails to mask the data in Fabric SQL Database. I got some confirmation yesterday at SQL Konferenz that this really looks like a bug and therefore I'm sharing the full code with you to reproduce and hopefully find a solution.   DROP TABLE IF EXISTS dbo.MaskingTable;   CREATE TABLE dbo.MaskingTable ( ID int IDENTITY(1,1), FirstName varchar(20) MASKED with (FUNCTION = 'Partial(3,"AbC",1)') NOT NULL, LastName varchar(30) MASKED with (FUNCTION = 'default()') NOT NULL, Email varchar(40) MASKED WITH (FUNCTION = 'email()') NOT NULL, SecretDate datetime MASKED WITH (FUNCTION = 'datetime("Y")')NOT NULL, TopSecretNumber int MASKED with (FUNCTION = 'RANDOM(1,1000)') )   INSERT INTO dbo.MaskingTable (FirstName, LastName, Email, SecretDate, TopSecretNumber) VALUES ('Hello There', 'Obi Wan', 'Kenobi@Rebellion.Empire', '1900-01-01', 99), ('Try there is not', 'Yoda', 'MasterYoda@Rebellion.Empire', '1945-01-01', 99), ('UWAAHguuuhff', 'ChewBakka', 'Chewy@Rebellion.Empire', '2025-07-29', 99)   SELECT * FROM dbo.MaskingTable   CREATE USER NoUnMask WITHOUT LOGIN; GRANT SELECT ON dbo.MaskingTable TO NoUnMask;   EXECUTE AS USER = 'NoUnMask' SELECT * FROM dbo.MaskingTable REVERT; ... View more