This is MASSIVE!!! we've written crazy workarounds in the past to 'advertise' key business events out of the SQL DB into to modern eventing systems like Event Hub. This new feature will save HOURS and HOURS and throw away very costly custom solutions.
Davide this feature is amazing and I am looking forward to use it. Thank you for what you and your team are doing to help us developers to deal with big challenge using Azure Sql.
Great demo Davide and such a welcome feature. I'm already thinking of solutions that might benefit from this. I was wondering if this can also be used from a trigger? (of course keeping in mind the number of triggers and performance).
Yes, of course. If you do so, I recommend using an async service like Event Hub or Azure Durable Functions to make sure the REST call is the fastest possible
I experienced a limit that only 500 rows can be returned when querying a published Power BI dataset. Can you advise if this is this expected or I should see more?
@@DavideMauri This is a great demo, I have seen your other Microsoft AZ Series too. Thanks for great work. My question still is about On-Prem SQL Server, this thread is an year old but Microsoft official information hasnt posted anything about this being available for On Premise. Any Updates for us?
This is MASSIVE!!!
we've written crazy workarounds in the past to 'advertise' key business events out of the SQL DB into to modern eventing systems like Event Hub. This new feature will save HOURS and HOURS and throw away very costly custom solutions.
We're so happy to hear that you're excited about the new feature!
Davide this feature is amazing and I am looking forward to use it. Thank you for what you and your team are doing to help us developers to deal with big challenge using Azure Sql.
This is amazing. I remember few years back I used SQL CLR to call a web service from SQL server. ❤❤
This has its place and needs to be used based on your use cases. Great job! Davide!
This is super useful. Please cover how to add external sites. Do you just use API Gateway? Please also this will come to managed instances
This is a very useful and dangerous feature. I am glad it is behind APIM so you apply policies on queries
Great demo Davide and such a welcome feature. I'm already thinking of solutions that might benefit from this. I was wondering if this can also be used from a trigger? (of course keeping in mind the number of triggers and performance).
Yes, of course. If you do so, I recommend using an async service like Event Hub or Azure Durable Functions to make sure the REST call is the fastest possible
Yes, I was thinking about that... thanx. I will be playing around with this in the coming month 😃
Welcome to the most expensive web service client in history ...and yet, that's pretty cool.
Ah ah but also the most useful
True its expensive if its wasnt optimized..
I experienced a limit that only 500 rows can be returned when querying a published Power BI dataset. Can you advise if this is this expected or I should see more?
Can someone provide a case where this kind of functionality would be useful?
Any option available to ignore ssl error during Api call ?
Only HTTPS is supported (for security reason) and the certificate must be valid (and also only TLS1.2+ is supported)
@@DavideMauri thank
Is this feature coming to on premise SQL server?🌚
Yep. Cannot give an ETA at the moment, but we know it is important to have it also on-prem and on Azure SQL MI
@@DavideMauri You made my day🙏
@@DavideMauri This is a great demo, I have seen your other Microsoft AZ Series too. Thanks for great work. My question still is about On-Prem SQL Server, this thread is an year old but Microsoft official information hasnt posted anything about this being available for On Premise. Any Updates for us?
Not a fan of this at all. People in SQL routinely try to do OO programming , and now you’re doing this?
This will save so much effort fixing bad data from NOSQL “engineers” who have to deal with a RMBDS for the first time in their life