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.
What you'll learn
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#.
Table of contents
- Why Stream Files with SQL Server? 2m
- Introducing FILESTREAM 2m
- Traditional Options - BLOBs in the Database 2m
- Traditional Options - BLOBs Outside the Database 3m
- BLOB Storage with FILESTREAM 4m
- Enabling FILESTREAM - Introduction 2m
- Determining the FILESTREAM Access Level 2m
- Enabling FILESTREAM for Windows and SQL Server 3m
- Demo: Enabling FILESTREAM 5m
- Creating a FILESTREAM Database 3m
- Demo: Creating a FILESTREAM Database 4m
- Creating a Table with FILESTREAM Columns 2m
- Demo: Using T-SQL to Access FILESTREAM Data 10m
- Improving I/O Scalability 4m
- Summary 2m
- Storage vs. Access 3m
- Introducing SqlFileStream 5m
- Storing and Retrieving BLOBs with SqlFileStream 4m
- Demo: Storing BLOBs with SqlFileStream 21m
- Demo: Retrieving BLOBs with SqlFileStream 3m
- Building SqlFileStream Client Applications 4m
- Demo: Building a Client/Server SqlFileStream Application 16m
- Demo: Building an N-Tier SqlFileStream Application 11m
- Summary 1m
- Introducing FileTable 3m
- FileTable Schema 4m
- FileTable Access 4m
- FileTable Prerequisites 3m
- Getting Started with FileTable 3m
- FileTable Database Objects 3m
- Demo: Creating a FileTable 6m
- FileTable Functions 2m
- Demo: Populating a FileTable 17m
- Demo: Querying and Manipulating a FileTable 10m
- Limitations and Considerations 5m
- Best Practices 6m
- More Information 3m
- Summary 1m
About the author
Leonard Lobel (Microsoft MVP, SQL Server) is the chief technology officer and co-founder 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., one of only 40 Microsoft National Systems Integrators in the United States. For more than 25 years, Tallan has been providing cutting-edge custom web/application development, business intelligence, customer relationship management, and int... more