SQL Server 2012-2014 Native File Streaming

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.
Course info
Rating
(108)
Level
Intermediate
Updated
Feb 13, 2015
Duration
3h 51m
Table of contents
Getting Started with FILESTREAM
Programming with SqlFileStream
Working with hierarchyid
Using FileTable
Description
Course info
Rating
(108)
Level
Intermediate
Updated
Feb 13, 2015
Duration
3h 51m
Description

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#.

About the author
About the author

Leonard Lobel (Microsoft MVP, SQL Server) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Lenni is also a consultant, trainer, and frequent speaker at major industry conferences.

More from the author
Learning Azure Cosmos DB
Intermediate
6h 6m
Apr 27, 2018
SQL Server 2016 New Features for Developers
Intermediate
3h 42m
Oct 14, 2016
Introduction to Azure DocumentDB
Beginner
5h 5m
Sep 23, 2015
More courses by Leonard Lobel