Advertisment

Today we will discuss about Microsoft SQL Server and external blob storage. Microsoft SQL Server is a highly efficient resource manager for structured data in a SharePoint content database. It is also provides a fast, efficient SQL query engine and exceptional query-based retrieval of structured data.

What about Blob? Blob is binary large object data files and in fact, SQL Server offers less of a gain for binary data than for structured data. Blob which correspond with SharePoint files often comprise a majority of your data.

SQL Server is not the best option for storing unstructured binary data streams. So, what should we do about it? Well, this is when we need External Blob Storage. We need this so we can get a simple and cost effective storage medium to function as an external Blob store. Remember that you have to install, register, and configure the External Blob Storage Provider on each of the front-end Web servers for each SharePoint site. If you wish to know more about Microsoft SQL Server or External Blob Storage then I suggest you to visit this site now. You will find complete information about Microsoft SQL Server or External Blob Storage and how it works.