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)
- Downloads
- SpeakerBIO
Leonard Lobel is a SQL Server MVP and cofounder/CTO of Sleek Technologies, Inc., a New York–based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, CodeCamp, and other industry conferences worldwide. Lenni is also lead author in the MS Press book “Programming Microsoft SQL Server 2008” which he is currently updating for SQL Server 2012. He can be reached at
lenni.lobel@sleektech.com.
- Video
The video is not available to view online.
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.