Link to home
Start Free TrialLog in
Avatar of Jaime Olivares
Jaime OlivaresFlag for Peru

asked on

SAS-like access for a SQL Blob field

Currently I use Azure's Shared Access Signature to access blobs directly, bypassing the web service. This has a great benefit in performance, as the blob doesn't need to travel from the storage to the web service, and then to the client application.
I want to know if there is a similar mechanism in MS-SQL: I would like to provide an accessible and secured URI to the client app, so it can download an specific blob straight from the database. I don't want to provide unlimited access to the DB, like OData, just to a specific record.
Thanks in advance.
Avatar of DcpKing
DcpKing
Flag of United States of America image

Can you not store your blobs in Azure and use a Shared Access Signature as you do now? That would seem the easy and effective way, as you know how to program the delivery already, and you have the Azure access already, etc.

hth

Mike
Avatar of Jaime Olivares

ASKER

Hi Mike, I am not asking for an Azure solution, but a non-Azure solution. That's the whole point of my question.
SOLUTION
Avatar of DcpKing
DcpKing
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My question points to a SQL-Server solution (if exists, that's the question), not to a file server solution. That's why I mention the term Blob instead of file.
I saw that, Jaime, but you are asking for a URI for data retrieval and that implies either a file of some sort or else a software layer to translate the URI into some sort of retrieval mechanism.  IMHO a straight file would be easiest, as you could secure that most easily using available tools. Have you thought of using SQL Server's FileStream to keep the blobs in the filesystem and allowing the applications to get them directly from there?
Sorry, I still don't have my answer, I would like to know if there is a ready-made product to expose SQL blobs in a similar way as Azure's SAS. After I get it, I may look for other alternatives.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial