22-25 April 2026 
SQLBits 2012
Native File Streaming with SQL Server 2012
This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.
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!
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!
Speakers
Leonard Lobel's previous sessions
Securing Azure Cosmos DB
Implement network security with the IP firewall, VNet access, and private endpoints, understand the various authentication options using master keys, resource tokens and Azure AD integration, learn about built-in server-side encryption, and how to configure client-side encryption using Always Encrypted.
Geospatial Data Types in SQL Server 2012
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
Native File Streaming with SQL Server 2012
This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.