BLOB Content in SharePoint – How Much Fat Can Be Trimmed?

I’ve been hearing a lot of chatter recently regarding BLOB (Binary Large OBject) storage in SQL. In fact, people have been talking about it many years. Thankfully, there are quotas which can be enforced, however, you still need to store BLOBs (photos, images, videos, documents – basically any attachments or files uploaded into SharePoint are BLOBs) in SharePoint, and SQL disk space can be, and is expensive.

Now, there are a lot of companies, some who are partners with Grace-Hunt, which make use of functionality within the SharePoint API to store files out of band from SQL, maintaining these BLOBs just as if they were in SQL. One of those companies, StoragePoint. They have a free tool, called BLOBulator, which is definitely geared towards their product, however, it is a great tool to peer into your SharePoint environment, and see how much space you actually can save by using an out of band BLOB storage solution such as theirs.

This is not a marketing effort – however, more of a reference point for myself to remember this tool, and share it with others who may have some use for it.

 

Advertisement

About Geoff Varosky
Geoff Varosky is a Senior Architect for Insight, based out of Watertown, MA. He has been architecting and developing web based applications his entire career, and has been working with SharePoint for the past 15 years. Geoff is an active member of the SharePoint community, Co-Founder and Co-Organizer of the Boston Area SharePoint Users Group, co-founder for the Boston Office 365 Users Group, co-organizer for SharePoint Saturday Boston and speaks regularly at SharePoint events and user groups.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: