SQL Server 2012-2014 Native File Streaming

English | 14 Feb 2015 | mp4 | H264 1024x768 | AAC 2 ch | 3 hrs 51 min | 630 MB

eLearning | Level: Intermediate | Exercise files

This course teaches unstructured data storage with FILESTREAM, hierarchyid, and FileTable. It explains T-SQL access, as well as streaming API access with SqlFileStream in client applications.

This course teaches SQL Server developers the ins-and-outs of unstructured data storage and native file streaming of documents, images, and other binary content with FILESTREAM (introduced in SQL Server 2008) and FileTable (added in SQL Server 2012). Students learn how to work with FILESTREAM using T-SQL and, for maximum performance, by programming the SqlFileStream class in C#. We also explain the hierarchyid data type, which casts a hierarchical structure over every FileTable, which enables SQL Server to emulate a functional file system to end-users and client applications. Demos include T-SQL scripts, as well as Windows Forms, ASP.NET, WPF, and WCF applications that demonstrate the high-performance SqlFileStream pattern using Visual Studio 2013 and C#.