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

Let me know what you think, or ask a question...

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.