Storing and Searching Files in SQL Server Filetables – Sam Nasr (20220412)

Topic:

FileTables is a SQL Server feature that allows easy storage and access to documents dynamically.

After some initial setup, users can simply drag files into a folder and then be able to access their meta-data and contents through SQL Server, seamlessly. Due to the way FileTable uses the FileStream feature, it stores files on the file system but maintains the metadata in the database. This allows full control over the file while not bloating the database.

Speaker:

Sam Nasr

Sr. Software Engineer (NIS Technologies)

Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, and MCT), Sam develops, teaches, and tours the country to present various topics in .Net. He’s involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.

Links:

https://www.meetup.com/dba-fundamentals-group/events/282471218