Arun Sirpal shows how to write an Azure SQL Database extended events session to blob storage:
Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks via the ring buffer. Ever since then I wanted to do a follow-up post but using Azure storage as the target for my XEL files.
This is more complicated than using the ring buffer as the target and requires a couple of things:
-
Azure storage account where you create a dedicated container for the files.
-
SAS key.
-
Database master key.
-
Database scoped credential.
Also, fantastic obfuscation in the post. Hello, Shane!