Are there any differences in data type in an Azure SQL Server DB for fields stored in Blob storage (already connected) or is it all connected by default?

Matthew 1 Reputation point
2020-08-29T23:21:21.593+00:00

I am trying to store videos and images efficiently in my SQL Server DB (on Azure). I set up the Azure SQL Server DB, and I linked it to Blob Storage.

Are all fields stored in Blob storage by default, or is there something I need to specify in the configurations or in the tables themselves? I currently have Videos and Images to be stored as varbinary(MAX). Is this the correct configuration?

Also, if this is not the best way to go about storing media content, is there a way that you would recommend instead?

Azure SQL Database

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.