SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.

An Introduction to SQL Server FileStream

Filestream allows us to store and manage unstructured data in SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly. However, it became clear that we were missing out on some extraordinarily useful functionality, so we asked Jacob Sebastian to come up with a simple and clear-cut account of the FILESTREAM feature in SQL Server 2008. You'll agree he has managed the feat superbly.

Implementing SQL Server 2008 FILESTREAM functionality

Learn to enable the FILESTREAM feature in SQL Server 2008 and configure your database to support it.

FILESTREAM Storage in SQL Server 2008

This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM with other features, and implementation details such as partitioning and performance.

FILESTREAM

New features in SQL Server 2008 justify migration

New features such as the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL 2008 a no-brainer.

FILESTREAM Data

Managing Files with SQL Server 2008's FILESTREAM Feature

SQL Server's new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.

The FILESTREAM Data Type in SQL Server 2008

There is a new data type in SQL Server 2008 that might help you deal with all those music, image, and other media files in SQL Server. FILESTREAM allows you to store these files in the file system, but access them from within SQL Server. New author Deepa Gheewala brings us a look at setting a table for FILESTREAM.

Configure Filestream in SQL Server 2008

SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.