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…

Running GO as a Windows Service

Lately I've been spending time writing GO (or GOLANG) applications. I'm a big fan of the language. Often what I write needs to run as a Windows service. I've found a few things you can do to make your life easier. Use a Shell There are three "shells"…

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…

SQL Server Extended Events in Production

I have finally jumped on the Extended Events bandwagon. It was tough to pry Trace and Profiler from my cold, legacy hands! But I'm mostly there. I'm still working on a good way to hook up ClearTrace to these things. It might be as simple as requiring you to pull…

Is It SQL - 1.0.28 now with better AG backups

It's finally time to push another release of Is It SQL out the door. This has a few big features I've been working on. Backups First, it handles remote Availability Group backups properly. In an AG, you can run a backup on a secondary node. IsItSQL now finds backups on…

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…

Is It SQL - 1.0.27

I'd like to tell you this release has some great unifying theme. It doesn't. It's just a bunch of things I felt like fixing. But let's start with tags. That's what I originally wanted to focus on for this release. The first change is to separate out the user-tags from…

Is It SQL has an Admin GUI

It's finally time to push Is It SQL 1.0.25 out the door. I sent it to the newsletter subscribers last week and we haven't discovered any problems yet. Before upgrading, please read the README in the zip file! Especially if you have custom connection strings and this is…

Is It SQL build 24 shows missing backups

The latest release of Is It SQL now shows missing backups. Backups The top section gives you a summary of all servers with missing backups and the bottom section lists each individual database that doesn't have a good backup. Right now a "good" full backup is defined as…

Configuring MSDTC Across Domains

One of my clients has applications that use MSDTC.  We’re spinning up a SQL Server 2016 Availability Group to take advantage of the MSDTC support it introduced.  Most of these distributed transactions take place across linked servers.  And of course the new servers are in a new domain with…