A blog by Jose Barreto, a member of the File Server team at Microsoft.
All messages posted to this blog are provided "AS IS" with no warranties, and confer no rights.
Information on unreleased products are subject to change without notice.
Dates related to unreleased products are estimates and are subject to change without notice.
The content of this site are personal opinions and might not represent the Microsoft Corporation view.
The information contained in this blog represents my view on the issues discussed as of the date of publication.
You should not consider older, out-of-date posts to reflect my current thoughts and opinions.
© Copyright 2004-2012 by Jose Barreto. All rights reserved.
Follow @josebarreto on Twitter for updates on new blog posts.
As I mentioned in a previous blog post at http://blogs.technet.com/josebda/archive/2008/03/17/sql-server-2008-and-unstructured-data.aspx, SQL Server 2008 introduces new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005.
One of those options is the new SQL Server Remote Blob Store, a method for storing blobs of unstructured data in a remote server, external to SQL Server. RBS is part of the add-on feature pack for SQL Server 2008. With RBS, you can store BLOBs on a Remote Blob Store (RBS). An RBS store is typically a separate box on same the network as the SQL Server. This is managed by SQL Server and integrity between the database records and the RBS external store is maintained.
Using RBS, your application can store large amounts of unstructured data (like videos or office documents), enjoying both the relational capabilities of SQL Server and the scalability of a dedicated blob store. Best of all, you do not have to write the code to handle the job of tying the SQL metadata and the blob data together. Transactional consistency is completely handled by RBS.
With the release of the Feature Pack Release Candidate 0 for Microsoft SQL Server 2008 to the web, you can now experiment with RBS. The download includes a client-side DLL that you can use in your applications and also some stored procedures to install on the SQL Server itself. The RBS RC0 setup program is available for X86, X64, and IA64 computers. It requires the Microsoft Installer 4.5.
The documentation included in the RC0 package provides sample code on how to:
The documentation also describes and provides examples on how to use the RBS storage procedures:
Download the RBS RC0 and start experimenting… Here’s the link: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=089a9dad-e2df-43e9-9cd8-c06320520b40
The RBS team also released a sample application showing the many ways to use this new feature, including:
This package also includes a sample file provider, in case you do not have an RBS store to test your application. Be sure to install the sample provider (the instructions are available at the CodePlex site) before you try storing and reading blobs.
Download the sample and leave comments at http://www.codeplex.com/sqlrbs
Last but not least, make sure to check recently created RBS team blog at http://blogs.msdn.com/sqlrbs
Jose Barreto, a member of the Storage Solutions Division Team here at Microsoft has put together a great
EMC has a Centera RBS provider for the SQL Server 2008 Remote BLOB Storage (RBS) feature. This allows a SQL Server application to use the RBS API to store BLOB data remotely on an EMC Centera device instead of inline in the SQL Server database. It is available on EMC Labs (see link, registration required for downloads)
EMC Centera Corporate Systems Engineering
SharePoint storing BLOBs in SQL Server carry its overhead (cost, doc size & storage limits…) and