xxHash32

A SQLCLR SAFE implementation of xxHashSharp, which returns a xxHash32 has as SqlInt32, that can be deployed to SQL Server or Azure SQL Managed Instance.

Note that only SAFE assemblies are supported in Linux and as such only Supported Libraries may be referenced in the assembly. xxHashSharp's code base meets this requirement.

Path to implementation

1. Compile xxHashSharp.cs to a .NET Framework 4.8 assembly named SqlxxHashSharp.dll
2. Copy SqlxxHashSharp.dll to a location accessible by SQL Server.
3. Create the assembly in a database:

create assembly xxhash32 from 'c:/tmp/CLR/SqlXxHashSharp.dll' with permission_set = safe;

4. Create a function referencing the method to be called:

create function dbo.XxHash32(@Value varbinary(max))
returns int
external name xxhash32.xxHashSharp.HashToInt32;

5. Test it...

declare @vb varbinary(max) = convert(varbinary, 'hello world');
select dbo.XxHash32(@vb);

6. Verfiy it...

-826579422 is 0xCEBB6622, which matches the output from Generate a xxh hash value

7. Declare victory!