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…