Ability to export Azure SQL Performance Recommendations
Our production Azure SQL does not allow developers to access (segregation of duties and security considerations). However, we want to share developers with Azure SQL performance recommendations so that they can improve the product logic.
It seems Azure SQL Contributor permission is required for developers to review the details. If can allow export the recommendations, it could be performed automatically, then it will be very helpful.
I guess other organizations could have similar challenges?
Andrew Stanton commented
Yes. Any organization that uses version controlled sqlproj kind of needs this. Even if we have permission to see the recommendation, we are never going to click the button to apply it directly. The change has to originate from a workitem in DevOps (or whatever change/work tracking used) before it can be promoted. Any kind of export would save a bunch of manual transcribing. A "create workitem" button like app insights has would also be nice.