FILETABLEs: What They Are and How to Use Them

Have you ever had the need to access documents in your
database as if they were files in the file system? SQL Server 2012 introduces a
brand new method for managing large data objects (BLOBs) in a database.
FileTables provide access to data using Transact-SQL - just like any other table
inside the database, while at the same time also provide access to the data
using the operating system File I/O API - i.e. just like any other folder in the
file system.

In this session you will learn how to upgrade your
document management solutions by migrating your large data to FileTables. The
session covers two most typical migration scenarios: migrating from a
distributed data store, where files are stored outside the database, and from a
homogeneous database, where files are stored inside the database, but need to be
accessible from the file system as well.
Presented by Matija Lah at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Matija_Lah.jpg
    Matija Lah is an independent consultant in the general and legal information management domains. Data warehousing represents and essential data management element in practically any business domain and Matija has had the opportunity to solve a variety of data warehousing problems since he started working with data warehouses in 2001. He shares many of his experiences in his blog at http://milambda.blogspot.com, and is one of the authors in the popular book series SQL Server MVP Deep Dives. He is a frequent speaker on conferences related to technologies built on top of Microsoft platforms, especially conferences dedicated to Microsoft SQL Server. Matija has been a Microsoft Most Valuable Professional for SQL Server since 2007, and is a mentor in SolidQ, a trusted global provider of advanced consulting, mentoring and education solutions for the Microsoft platforms.
    http://milambda.blogspot.com/ http://feeds.feedburner.com/SnapsSnippets
  • Video
    The video is not available to view online.