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 http://connect.microsoft.com/SQLServer/feedback/details/688000/filetable-permissions-enhancements
  • 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

Performance

  • Recommendations and guidelines for improving SQL Server FileStream performance, Microsoft Support KB Article
    http://support.microsoft.com/kb/2160002

    • Documents low-level file system configuration

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s