Lesson Learned #373: Improving download transfer rate for LOB columns in Azure SQL Database
A few days ago, I have been working on reducing the data download transfer rate to improve the download ratio for Proxy or Redirect connections. I would like to share my lessons learned with two examples, using the COMPRESS and DECOMPRESS commands of SQL Server. We know, based on, this article: Azure SQL Database connectivity architecture - Azure SQL Database and Azure Synapse Analytics | Microsoft Learn the recomendation to use Redirect versus Proxy - "We highly recommend the Redirect connection policy over the Proxy connection policy for the lowest latency and highest throughput".
