Currently using varbinary(max) in database, which limits us to 2 GB per file. Filestream doesn't have that limit which is good.
There are some caveats we'll have to consider though.
> Encryption is not supported on FILESTREAM data.
We currently are under contract to always have data encrypted at rest for some customers. (Yay enterprise!)
> SQL logins will not work with FILESTREAM containers. Only NTFS or ReFS authentication will work with FILESTREAM containers.
We've got so many different environments that our database is hosted in, so this could be hard to do, but perhaps possible. A lot of governmental facilities as customers that will not connect their data to the internet means a real headache when introducing changes.
But I'll still will spend some time to evaluate this. It seems like the easiest technology to introduce and migrate to.