SQL Server errors are shown in Azure Log Analytics. Sometimes, the query_hash_s column is populated. But the values provided appear to be BIGINT. How can I use that value to find the actual text of the SQL statement using sys.dm_exec_sql_text? Simply converting the value to a VARBINARY(64) doesn't work.
Example value: 621553112374777528
SELECT CONVERT(VARBINARY(64), 621553112374777528)
results in 0x12000001B81623384333A008, whereas sys.dm_exec_sql_text is looking for a value that looks more like this (this is a different value, shown only to illustrate the length difference):