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
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.
Sorry, there are no downloads available for this session.
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.
The video is not available to view online.