From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Implement FILESTREAM access - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Implement FILESTREAM access
- [Narrator] SQL Server-based applications can store documents and images on a Windows file system, when a feature called FILESTREAM is enabled on the database. In this movie, I'm going to enable FILESTREAM on my instance of SQL Server and run through a very quick example of creating a database and a table, to take advantage of this feature. I want to preface this with the caveat that I'll be making several changes to my SQL Server configuration. So, I would recommend that you research the application of FILESTREAM databases and all of their configuration options and pitfalls before working through the process on your own machine. At the very least, I would consider a read-through of the SQL Server technical documentation on the topic a bare minimum requirement before beginning. Now, before I start the process, I want to create a new file folder on my local C Drive that we can use as our FILESTREAM location. I'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.