{"id":806,"date":"2015-05-28T14:37:20","date_gmt":"2015-05-28T13:37:20","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=806"},"modified":"2015-08-14T12:37:51","modified_gmt":"2015-08-14T11:37:51","slug":"what-is-filestream-in-sql-server","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/what-is-filestream-in-sql-server\/","title":{"rendered":"#Sql Server interview question: What is filestream in SQL Server?"},"content":{"rendered":"

Filestream allows you to store unstructured large objects (text documents, images, and videos) in the file system and have these files integrated within the database. Filestream basically integrates the SQL Server Database Engine with NTFS (New Technology File System); it basically stores the data in the varbinary(max) datatype.<\/p>\n

Using this datatype, the unstructured data is stored in the NTFS file system, and the SQL Server Database Engine manages the link between the Filestream column and the actual file located in the NTFS. Using Transact-SQL statements users can insert, update, delete and select the data stored in Filestream-enabled tables. Filestream data is not encrypted even when transparent data encryption is enabled.<\/p>\n

Thanks for reading this article,<\/strong><\/p>\n

Next steps :<\/strong><\/p>\n

    \n
  1. Share this with your colleagues because Sharing\u00a0 is Learning<\/strong><\/li>\n
  2. Comment below if you need any assistance<\/strong><\/li>\n<\/ol>\n

     <\/p>\n

    Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n

    Share this:<\/h3>