Ends a session in T-SQL, rolling back any transaction it has open. Fabric warehouses restrict it to workspace Admins, who usually look up the session ID in sys.dm_exec_requests first.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains KILL in context, with comparison tables and the common traps.
Terms in this definition
- T-SQL
The dialect of SQL that Microsoft uses for Azure SQL and SQL Server. Azure Monitor logs are queried with KQL instead.
- Workspace
Teams in Power BI and Microsoft Fabric collaborate in this folder-style container, which groups items such as reports, semantic models and lakehouses, controls who can access them and is assigned a capacity.
- FIRST
A DAX function available only inside visual calculations. It fetches the value at the start of one axis of the visual's matrix, which makes it handy for comparing each point with the first; its opposite is LAST.