How can we improve Azure SQL Database?

Implement FILESTREAM for blobs into Azure Blob Store

Storing blobs in the database is fairly pointless when you have a dedicated blob store. Implement the FILESTREAM protocol to store blobs in a user's azure storage

221 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    anonymousanonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared a merged idea: Sql Azure tables for Blob Storage  ·   · 
    Braulio MegiasBraulio Megias shared a merged idea: SQL Azure: Filestrestream datatype through the blob storage  ·   · 

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        a great think about storing files with filestream is to use the same database transaction all over the code and don't care if something goes wrong, because you can just rollback.

      • Brian McKinleyBrian McKinley commented  ·   ·  Flag as inappropriate

        This should include the ability associate a storage account with database, federation or federation "member." If a database, federation or federation member is dropped the associated blobs referenced in the tables should be deleted automatically from the blob storage. When a federation is split we should have the option to specify a new storage devices for the new federation member at the same time.

      • Daniel KornevDaniel Kornev commented  ·   ·  Flag as inappropriate

        Totally agree; enabling FileTables as part of SQL Azure would also enable full-text search and semantic search scenarios.

      • Ryan CrawCourRyan CrawCour commented  ·   ·  Flag as inappropriate

        Why would you want to store blobs in SQL Azure when storing blobs in Windows Azure Blob storage is orders of magnitude cheaper. Store your relational data in SQL Azure and your blobs in a storage abstract designed for this exact purpose.

      • TriSysTriSys commented  ·   ·  Flag as inappropriate

        Why use a separate API for Azure storage when we can use ADO.Net and get at SQL AND file data?

      Feedback and Knowledge Base