Storing Binary Data Types in SQL Server


Daily work rarely requires storing binary data directly to database columns. However, it is very useful in some cases.

Contrary to popular opinion, byte arrays can help with significantly more than just storing large binary objects (documents, multimedia, etc.). Also, they can be used to store hash values and sample data for faster searching/high-level analysis. Or, they might contain bytes that are in ON/OFF states in some electronic relay. As soon as we start to think about hardware data stored in databases, applications become more apparent.

CodingSight - Storing Binary Data Types in SQL Server
Read More