SQL Server 2012 (a.k.a Denali) – New feature | FileTables

new kid on the blog... this is my first post on MSDN Blogs after joining Microsoft very recently (Jan-2012).

I also used to blog on my personal bog site i.e. https://sqlwithmanoj.com about SQL Server (TSQL) and I'll start my 1st blog post here by referring to my latest article.

SQL Server 2012 (a.k.a Denali) is yet to be launched and entire Microsoft community is very excited for this event to occur, so am I. There are lot of articles comming up on various forums and blogs about new features and capabilities of SQL Server 2012.

Here I'll discuss about a new feature of SQL Server 2012 that came to my notice and grabbed my attention a few days back, It's called FileTables.

FilesTables is kind of an extention to FILESTREAM introduced with SQL Server 2008 to support files in Windows file system instead of storing them in SQL tables. This new feature brings support for the windows file namespace and compatibality with Windows Apps to the data files stored in SQL Server.

As per MS BOL, FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services, including: full-text search and semantic search - over unstructured data and metadata. In other words, you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications. Or can store directly in Windows file system and can access, query and update the files directly from SQL Server by issuing simple DML statements.

I've posted about this article with more details and a simple example can be viewed here.