This post discusses a specific issue related to SQL Server's default session-level setting that truncates binary data to 4KB before it reaches Ruby, highlighting that while most drivers correct this, the tiny_tds driver does not address the issue, which could lead to data loss.