SQL Server Remote Blob Storage (RBS) Credential Store Symmetric Key Rotation

The SQL Server team would like to advise RBS admins on security procedures for rotating the credential store symmetric key.  If a provider requires the setup and use of a secret stored within the credential store (see related article), RBS uses this symmetric key to encrypt any provider secrets which a client may request to…

0

Fixing RBS/Provider version mismatch issues

The problem Release of a new RBS library will cause the providers developed with older version to not work due to version mismatch. The symptoms Let’s take an example of SharePoint to understand where and how the problem might appear. On a running SharePoint instance with the RBS client and RBS providers installed, after an…

0

RBS Security Model

RBS stores blob data in external blob stores which often use a differing security method from SQL Server. This blog post details the RBS security model for administrators and provider developers. Master Key Requirement As part of the RBS installation a database master key is required to be set. This is used for RBS credential…

0

RBS Filestream Provider Small Blob Optimization Settings

The RBS Filestream Provider has a number of configuration options designed to ensure optimal read and write performance across a range of blob sizes. The defaults were chosen after performance testing on various hardware and should be left as-is unless there are specific circumstances that require modification. The term in-band refers to T-SQL access through…

1

Running RBS Maintainer

We are getting some questions on this through this blog and our codeplex site and I thought that this subject needs a detailed blog post, so here is some information on running RBS maintainer.   Connection Strings   RBS maintainer takes connection strings from a CLR config file (Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config) that is present in the same…


Multiple Blob Stores in RBS – Defaults and Explicit Store Selection

Recently I got a question on how a blob store is chosen for storing new blobs when multiple blob stores are present, and how to influence that choice. This might be of interest to many others and so I am writing this blog post. Please feel free to ask questions (using the contact features on…


SQL Server Remote BLOB Store and FILESTREAM feature comparison

  With the recent refresh of the RBS Feature Pack a brief comparison between RBS and the SQL Server FILESTREAM feature may be useful.   FILESTREAM and RBS are complementary approaches for storage and management of BLOBs and we see them both continuing to evolve. ·         FILESTREAM provides a storage option that allows storage, efficient…

6

Remote Blob Storage November CTP Refresh Available

The SQL Server 2008 R2 November Community Technology Preview Feature Pack is available for download now. This includes a refresh of the Remote Blob Storage package.   Significant enhancements have been made in this release for performance and integration with SharePoint 2010. These changes include implementing the IDisposable interface in the SqlRemoteBlobCollectionManager and SqlRemoteBlobContext classes….

3

SQL Server 2008 R2 Remote Blob Store August CTP Available

Updated RBS Packages are available as part of the SQL Server 2008 R2 August CTP release. This includes the new default FILESTREAM RBS provider along with many other enhancements and bugfixes. This provider is the first officially supported RBS Provider released by Microsoft and begins to bridge the gap between RBS and Filestream, allowing applications…

1

Exceptions to be Thrown by BlobStore Implementations

I recently got a question on what Exceptions a BlobStore implementation should throw and this blog post answers that question. BlobStore implementations should throw either BlobStoreException or other exceptions.   BlobStoreException is meant to be used for conditions that RBS client library expects and knows how to handle (either now or in the future). For…