MicrosoftHi,
I have tried the the new 'sp_invoke_external_rest_endpoint'.
First of all, its amazing finally to be able to invoke endpoints and it opens a wide range of exciting appliances within both analytics and application development. Now there is one more reason for using Azure SQL DB.
A few questions/wishes though
a) Throttling
It would be super nice if you either rise the cap for maximum worker threads (to for example 25 %) or even better make it configurable (with a default of 10 %).
I see some possible beneficial appliances where a Azure SQL database will be configured for the sole purpose of invoke API calls. In such scenarios the database has to be scaled up impropertionally much to support the necessary concurrency.
b) Payload Size
For many analytic appliances a maximum payload of 100 MB is not sufficient. If you can rise the max payload to 2 GB - like the native NVARCHAR(MAX) limit in Azure SQL Database - it would be beneficial also.
c) Managed Instance Support
Is there any plan to support Azure SQL Managed Instance also in the future?
Best regards,
Morten Lange
