Tag Archives: Filetable

FileTables–Inserting Directories from T-SQL

Creating a directory in a Filetable share is easy. It looks like this: It’s hard to see, but this was a right click, New, Folder in the share from Windows Explorer. However what about creating a directory from T-SQL? That’s … Continue reading

Posted in Blog | Tagged , , , | Comments Off on FileTables–Inserting Directories from T-SQL

FileTable–Adding a file to a folder

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, since I’d seen someone do this in .NET and was thinking this has to be simple. Turns … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Managing Data in a FileTable with T-SQL

I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do you work with the data in this table? In this post I’ll look at a few things you can do … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Managing Data in a FileTable with T-SQL

Filestream and Filetable in SQL Server

This talk is an update of my Unstructured Data in SQL Server talk that looks at the Filestream and Filetable features of SQL Server. This session begins by presenting a case why we will manage more binary (unstructured data) in … Continue reading

Posted in Presentations | Tagged , , , | Comments Off on Filestream and Filetable in SQL Server