It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Native File Streaming with SQL Server 2012

In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming in SQL Server 2012. Learn all about FILESTREAM, an innovative feature introduced in SQL Server 2008 that integrates the relational engine with the NTFS file system. FILESTREAM revolutionized BLOB storage in the database, and now FileTable, new in SQL Server 2012, builds on FILESTREAM to deliver a logical file system—implemented as a FILESTREAM-enabled table in your database—on top of your BLOBs. Lenni will demonstrate how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#.

We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and you’ll learn how to use this data type to perform hierarchical queries and tree manipulations within the FileTable (or any table). We’ll wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.

Attend this session, and gain a whole new perspective of BLOBs with SQL Server 2012!

(no tags)

To view this video please enable JavaScript, and consider upgrading to a web browser that supports HTML5 video

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.