ClearTrace for Extended Events

I found the time to update ClearTrace to support Extended Events.  You can download ClearTrace for Extended Events from my corporate site.  A few notes about this buildIt's a very early release.  Everything seems to work for me and it passes all the tests.  Please report any issues in the…

Send SQL Server Extended Events to Logstash (ELK)

ELK (or Elastic Search, Logstash, Kibana) is taking over one of my clients. And I have to admit it's a very handy tool. They are pushing all their logs into it and it's ver easy to search them. Fair warning: My ELK skills and knowledge are very rudimentary at this…

Get a Phone Alert When a Query Finishes

Today, through various snafus and situations, I found myself waiting a LONG time for a lock to clear up. Here's how I got an alert to pop up on my phone (an iPhone) when that stupid SPID finally rolled back. You'll need to have database mail configured and ready to…