FILESTREAM/FileTable Resources

THE Book on FILESTREAM and FileTable

The Art of SQL Server FILESTREAM

My Blog Posts

Complete list

Frequently Asked Questions

  • I want one group of users to have read-only access and another group of users to have read-write access to a FileTable. Can it be done?
    In short, no.
    This deals with row level security, which SQL Server does not currently support. See
  • In which update has the FileTable security flaw been resolved?
    It has been resolved in Service Pack 1. Be careful, because none of the RTM’s Cumulative Updates, including CU 5 released after SP 1 have the fix.
    I am continuing to test with every CU that Microsoft releases for RTM and will update the original blog post and this page when I find if it’s been resolved.

Best Practices


  • Recommendations and guidelines for improving SQL Server FileStream performance, Microsoft Support KB Article

    • Documents low-level file system configuration

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s