SQL Server 2011 Denali publishes tables as Windows network folders

I’ve been testing the new Community Tech Preview of SQL Server 2011, codenamed “Denali”.

Here is an intriguing feature. You can now create a new kind of table called a FileTable. A FileTable is mapped to a folder on the filesystem, though you are not meant to access it directly once it is managed by SQL Server. However, you can access the folder in Windows Explorer, or over the network, as a network share. When you do this, a SQL Server component intercepts the Windows API calls and updates the FileTable. FileTables build on the existing FILESTREAM feature in SQL Server 2008, and the documents in the folder are stored as FILESTREAM data.

The illustration shows a folder in Windows Explorer that is also a SQL Server FileTable.

image

Is this the return of WinFS, the fabled relational file system which was originally planned for Windows Longhorn, but abandoned? Not really. According to the docs:

FileTables remove a significant barrier to the use of SQL Server for the storage and management of unstructured data that is currently residing as files on file servers. Enterprises can move this data from file servers into FileTables to take advantage of integrated administration and services provided by SQL Server. At the same time, they can maintain Windows application compatibility for their existing Windows applications that see this data as files in the file system.

VN:F [1.9.18_1163]
Rate this post
Rating: 10.0/10 (4 votes cast)
SQL Server 2011 Denali publishes tables as Windows network folders, 10.0 out of 10 based on 4 ratings

Related posts:

  1. Server admin on the go with Microsoft’s Windows Phone 7 app for SBS 2011
  2. Remote access to files in Microsoft Small Business Server 2011
  3. Importing folders to SharePoint
  4. Here comes Windows Server 8 beta: what’s new since the Developer Preview?
  5. Windows Phone at Mix 2011: what Microsoft said and did not say

1 comment to SQL Server 2011 Denali publishes tables as Windows network folders

  • Interesting. I could definitely see this being used in the future to improve multimedia storage in SharePoint. Currently, you typically manage large (multi GB) libraries of media in SharePoint by implementing Remote BLOB Storage (RBS), due to the size constraints on the SharePoint content databases. However, the RBS option does not allow you to access the media except through the SharePoint API. Using the FileTable feature would allow you to share the media outside of SharePoint, but still administer it using the SharePoint features.