capture-with-extended-events

Creates, starts, reads back and drops a database-scoped Extended Events session on Azure SQL Database, and names the ways one reports success while capturing nothing. Use when someone asks to capture query text, blocking or deadlocks with Extended Events, XEvents or an XE session on Azure SQL Database, pastes a session that ran without error and left an empty ring buffer, or has a session that never fires. Covers ON DATABASE scope and the error ON SERVER raises, the ring buffer shredded from XML into a rowset, the event_file target's need for a blob URL and a matching credential, the events and actions the service refuses, and the absence of a built-in system_health session. Does not diagnose slow queries, blocking or resource pressure once the data exists (diagnose-slow-query, diagnose-blocking-and-deadlocks, diagnose-resource-pressure) or read a plan (read-execution-plan).