A Way Around "Binary Hell" in SQL Server

Warning: this article may offend your religious feelings - sorry about that. All others: play loud!

What is Hell? According to the famous rock band AC/DC (yeah!) it "ain't a bad place to be". For many people, regardless of their confession, it's supposedly some kind of dark pit, nobody knows exactly where it is, but it ought to be used to stow away the bad guys and gals for eternity. Once in a while it might happen that one of its "inhabitants" shows up on the surface, causing nothing but trouble ...

Believe it or not: SQL Server has such a place for the doomed, too. And it's got a name for hell: Binary Large Object, aka BLOB (or LOB for short).

BLOB data-types (in SQL text, image, etc.) are basically us...

read more