The link under "create a linked server using TDS remoting" to the CDATA page returns...

Excellent post; thank you.

I have slighty altered the code by replacing DATEDIFF(MS, tat.transaction_begin_time, GETDATE()) AS [TransDuration(s)] by CONVERT(VARCHAR,DATEADD(ms,DATEDIFF(MS, tat.transaction_begin_time, GETDATE()),0),114) AS [TransDuration] and the ORDER BY [TransDuration(s)] DESC by ORDER...

I finally succeeded by writing the output to a temp.txt file and adding the next PowerShell command to convert it to UTF-8:

-- Change encoding to UTF-8 with PowerShell...