Storing and Retrieving PDF Files in Azure SQL Managed Instance

Question

I use Azure SQL Managed Instance as DB and ADLS for file storage. Now the requirement is to store few small PDF files (about 200 kb each). Storing and retrieving will be done through .NET.

Which is the best and easiest approach?

1. Storing the PDFs in database as VARBINARY(max) column.
2. Storing the PDFs in ADLS.

Answer 1

Which is the best and easiest approach?

Since you're already using ADLS it's the best and easiest approach for file storage for your application.