Managing unstructured data through SQL 2008

Source: Internet
Author: User
Tags mail microsoft sql server sql 2008

Managing unstructured data through SQL Server 2008

SQL Server Technical Documentation

Author: Graeme Malcolm (Content Supervisor)

Technical Auditor: Shan Sinha

Project Editor: Joanne Hodgins

Release Date: August 2007

Applicable products: SQL Server 2008

Overview: The growth of digital information provides an inspiration for how businesses should store and access business data. As the core of business applications, databases must be able to integrate with unstructured data, including documents, images, video, and other multimedia formats. To be able to manage the information lifecycle, meet policy requirements, and implement content management solutions, organizations need to store and manage digitized data in all formats.

Microsoft SQL server™2008 provides a flexible solution for storing unstructured data and combining it with relational data to build a comprehensive solution around all the data in the enterprise.


This white paper is a preliminary document and may be completely modified before the software is finally commercially released.

The information contained in this document represents the current view of Microsoft Corporation (Microsoft Corporation) on the issues discussed at the date of release. Because Microsoft must comply with changing market conditions, this document should not be construed as a commitment by the Microsoft side, and Microsoft does not guarantee the accuracy of the information given after the date of release.

This white paper is for informational purposes only. Microsoft does not make any express, implied, or statutory warranty with respect to the information in this document.

It is the user's responsibility to comply with all applicable copyright laws. Without limiting the rights under copyright, no part of this article shall be reproduced or disseminated in any form or by any means (electronic, mechanical, photocopying, recording, etc.) for any purpose, in any manner or by any instrument (electronics, machinery, photocopies, recordings, and so on), in the express written permission of Microsoft Corporation, It may not be stored or introduced into a retrieval system.

This document may involve Microsoft's patents, patent applications, trademarks, copyrights, or other intellectual property rights. Unless expressly provided by Microsoft through a written license agreement, this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

Unless otherwise noted, the company described herein as an example, organizations, products, domain names, e-mail addresses, logos, people, places, and events are fictitious and do not have any contact with any real company, organization, product, domain name, e-mail address, logo, person, place, or event, nor should any conjecture or inference be made accordingly.

ó2007 Microsoft Corporation. All rights reserved.

Microsoft, Excel, SQL Server, and Windows are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

All other trademarks are the property of their respective owners.


Introduction 1

Commercial power of unstructured data 1

Challenges to unstructured data 1

Challenges for storing unstructured data 2

Challenges in using unstructured data 2

Target 2 of unstructured data in SQL Server 2008

Storing unstructured data in SQL Server 2008 2

SQL Server BLOB3


Remote BLOB Storage API3

Comparison of storage options for BLOBs 4

Searching for unstructured data in SQL Server 2008 4

Integrated Full-text Search 5

Conclusion 5

Related Article

Cloud Intelligence Leading the Digital Future

Alibaba Cloud ACtivate Online Conference, Nov. 20th & 21st, 2019 (UTC+08)

Register Now >

Starter Package

SSD Cloud server and data transfer for only $2.50 a month

Get Started >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.