Join Martin Guidry for an in-depth discussion in this video Using FileStream data, part of Designing Database Solutions for SQL Server 2012.
- In this section, I'd like to talk about…how we can use the FILESTREAM feature…of SQL Server 2012 in order to access…documents both through a traditional…SQL Server table and also through the file system.…So, were gonna have access to the same document…two different ways.…We'll be able to read it…or edit it through both techniques.…Either through a table…or through the file system.…In order to do this, we're first gonna need…to add a new file and file group…to the AdventureWorks database…that has the file stream enabled.…
I have some code staged for you…in the exercise file.…If you wanna copy just the top part…of that file over into a new query window…and we'll see two fairly straightforward commands.…The first one is going to alter the database,…AdventureWorks2012.…It's gonna add a new file group…and it says specifically that file group…will contain FILESTREAM data.…The next command is also gonna alter the database.…This one will add a file…and that file I'm calling F:/SharedData.…
If you don't have an F drive on your server…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.