Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « Microsoft SQL Server 2008 Feature Pack October 2008 Available For DownloadThe Manga Guide to Databases »
    comments

    Paul Randal has written a very detailed technical article about 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.

    This white paper is targeted at architects, IT Pros, and DBAs tasked with evaluating or implementing FILESTREAM. It assumes the reader is familiar with Windows and SQL Server and has at least a rudimentary knowledge of database concepts such as transactions.

    Here is the table of contents:

    Introduction
    Choices for BLOB Storage
    Overview of FILESTREAM

    –Dual Programming Model Access to BLOB Data
    –When to Use FILESTREAM
    Configuring Windows for FILESTREAM
    –Hardware Selection and Configuration
    –Physical Storage Layout
    –RAID Level Choice
    –Drive Interface Choice
    –NTFS Configuration
    —-Optimizing NTFS Performance
    —-Cluster Size
    —-Managing Fragmentation
    —-Compression
    —-Space Management
    —-Security
    –Antivirus Considerations
    –Enabling FILESTREAM in Windows
    Configuring SQL Server for FILESTREAM
    –Security Considerations
    –Enabling FILESTREAM in SQL Server
    –Creating a Database Enabled for FILESTREAM
    –Creating a Table for Storing FILESTREAM Data
    –Configuring FILESTREAM Garbage Collection
    –Partitioning Considerations
    –Load Balancing of FILESTREAM Data
    –Feature Combinations and Restrictions
    Performance Tuning and Benchmarking Considerations
    Data Migration Considerations
    FILESTREAM Usage Best Practices
    Conclusion

    You can find that technical article here: http://msdn.microsoft.com/en-us/library/cc949109.aspx

    You also check out Paul Randal’s blog here: http://www.sqlskills.com/blogs/paul/

    About the Author

    User bio imageDenis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
    Social SitingsTwitterFacebookLinkedInHomePageFlickrLTD RSS Feed
    4210 views
    InstapaperVote on HN

    No feedback yet

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)