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.
LVL 55
Jaime OlivaresSoftware ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DcpKingCommented:
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
0
Jaime OlivaresSoftware ArchitectAuthor Commented:
Hi Mike, I am not asking for an Azure solution, but a non-Azure solution. That's the whole point of my question.
0
DcpKingCommented:
Your question then must start with "can I create a secure URI to a file on my file server". What you mean by "accessible" I don't know. Until you can arrange with your infrastructure managers to be able to let untrusted external users access files on a server you're stuck. That, then, is your first task.

Mike
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jaime OlivaresSoftware ArchitectAuthor Commented:
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.
0
DcpKingCommented:
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?
0
Jaime OlivaresSoftware ArchitectAuthor Commented:
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.
0
Anthony PerkinsCommented:
No.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.