MS-SQL Server - Hex and Tune-art

Hexagon

 

Well, there is no Hexagone as such is regards to SQL Server but we have something to discuss today..

HEX

https://learn.microsoft.com/en-us/sql/integration-services/expressions/hex-ssis-expression?view=sql-server-ver16

https://support.microsoft.com/en-us/office/hex-function-8142792f-c077-485b-947f-fa3c7698a560

On the other side there is conversion syntax from Hex to other datatype. Refer the below image and links.

Tune-art

Fine Tune your SQL database is also an art.

Additionally,

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a05e1c18-be5a-4162-a9d2-1092b307bd22/hexadecimal-to-string-conversion-in-sql-server?forum=transactsql

https://techcommunity.microsoft.com/t5/sql-server-blog/sql-server-2008-new-binary-8211-hex-string-conversion/ba-p/383490#:~:text=NEW%20%E2%80%93%20IN%20SQL%20SERVER%202008,binary%20data%20%E2%80%93%20hex%20string%20conversion.

Best Regards

T. Amit Vaid S.