Browse by Tags

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...

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...

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...

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...

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...

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...