SQL Server 2012-2014 Native File Streaming

By Leonard Lobel
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
(113)
Level
Intermediate
Updated
Feb 13, 2015
Duration
3h 51m
Table of contents
Getting Started with FILESTREAM
Why Stream Files with SQL Server? 2m Enabling FILESTREAM for Windows and SQL Server 3m Enabling FILESTREAM - Introduction 2m Traditional Options - BLOBs Outside the Database 3m Traditional Options - BLOBs in the Database 2m Determining the FILESTREAM Access Level 2m Introducing FILESTREAM 2m BLOB Storage with FILESTREAM 4m Creating a FILESTREAM Database 3m Demo: Using T-SQL to Access FILESTREAM Data 10m Summary 2m Demo: Enabling FILESTREAM 5m Creating a Table with FILESTREAM Columns 2m Improving I/O Scalability 4m Demo: Creating a FILESTREAM Database 4m
Programming with SqlFileStream
Building SqlFileStream Client Applications 4m Storing and Retrieving BLOBs with SqlFileStream 4m Storage vs. Access 3m Demo: Storing BLOBs with SqlFileStream 21m Demo: Building a Client/Server SqlFileStream Application 16m Summary 1m Introducing SqlFileStream 5m Demo: Building an N-Tier SqlFileStream Application 11m Demo: Retrieving BLOBs with SqlFileStream 3m
Working with hierarchyid
Summary 1m Introducing hierarchyid 3m Indexing hierarchyid Columns 2m Demo: Populating a Hierarchal Table 13m Demo: Querying a Hierarchical Table 2m Demo: Manipulating a Hierarchical Table 6m Common hierarchyid Methods 2m Traditional Self-Join Approach 1m Demo: Avoiding Node Collisions 10m
Using FileTable
FileTable Prerequisites 3m FileTable Access 4m Demo: Populating a FileTable 17m Demo: Creating a FileTable 6m FileTable Database Objects 3m More Information 3m Summary 1m Demo: Querying and Manipulating a FileTable 10m FileTable Functions 2m FileTable Schema 4m Getting Started with FileTable 3m Introducing FileTable 3m Limitations and Considerations 5m Best Practices 6m
Description
Course info
Rating
(113)
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
Leonard Lobel
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
Building Event-driven Microservices with the Azure Cosmos DB Change Feed
Intermediate
2h 38m
Jun 30, 2020
Data Modeling and Partitioning Patterns in Azure Cosmos DB
Intermediate
1h 47m
Mar 25, 2020
Learning Azure Cosmos DB
Intermediate
6h 3m
Sep 25, 2019
More courses by Leonard Lobel

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT