[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

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.
0
Jaime Olivares
Asked:
Jaime Olivares
  • 3
  • 3
2 Solutions
 
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 OlivaresAuthor 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
Jaime OlivaresAuthor 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 OlivaresAuthor 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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now