title: Compressing TCP in SQL Server 2008
body: <p>We have .NET 4.0 application using Entity Framework. Application connects remotely over TCP to the SQL Server. When on LAN, it's fast, but over internet the traffic is very high.</p>
  
  <p>All we would like to do is to turn on some <code>TCP compression</code> but it looks like that SQL Server 2008 doesn't provide this feature.</p>
  
  <p>What's the simplest solution to make TCP communication compressed?</p>