Unique Document URLs in MOSS 2007 and the new Document ID feature in SharePoint 2010

A few years ago, I was working with a Microsoft customer to deploy a Microsoft Office SharePoint Server (MOSS 2007) solution. SharePoint 2007 had just been released at the time. The customer needed document URLs stored in SharePoint to continued to work even after the document was renamed or moved. I blogged about the issue and a…

0

To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem

While attending a class on SQL Server, I was introduced to a paper from Microsoft Research (authors are Russell Sears, Catharine Van Ingen and Jim Gray) that discusses whether to store large objects in a filesystem or in a database, depending on the size of the object in question. White Paper Title: To BLOB or…

0

SQL Server Remote Blob Store (RBS) available as part of the Feature Pack RC0 for Microsoft SQL Server 2008

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…

3

SQL Server 2008 and Unstructured Data

SQL Server 2008 introduces two new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. IMAGE Back in SQL Server 2000 and SQL Server 7 days, we used the IMAGE data type to store binary large objects (a.k.a. BLOBs). Large, by the way, is defined as…

3

The Legend of the Single, Multi-Terabyte, Replicating SharePoint Database

Documents in Databases The first time I tell anyone that SharePoint Server 2007 stores documents as blobs (binary objects) in the database, people stare at me for a few seconds and usually ask: “Really?” It takes a few moments to explain that this is actually a good thing and that SQL has no problem handling…

1

Unique Document URLs in MOSS 2007

P.S.: There’s now a feature in SharePoint 2010 to address this: See http://blogs.technet.com/blairb/archive/2009/10/20/new-document-id-feature-in-sharepoint-2010.aspx I’m currently working on a Microsoft Office SharePoint Server 2007 implementation at a large customer that uses LiveLink. They need a feature not currently available out-of-the-box in SharePoint, so these are some ideas on how we’re planning to do it. Most of the concepts were…

1