- Simple web interface for killing sessions in Synapse Dedicated SQL Pool.
- Based on Blazor Web assembly and Azure Functions.
- Uses Azure AD for authentication and authorization of API, application, and end users.
This application solves the limitation of Synapse Dedicated SQL Pool - you cannot grant permission to users for killing their queries only. The app provides a web interface where users can see their running queries and run the KILL command for selected sessions.
Take a look at the article for a detailed explanation.