SQL Server Desired State Configuration

At one of my clients, I've seen the benefits of using tools like Puppet to push configurations to servers.  I've long tried to write idempotent configuration scripts for my servers.  Those are scripts that can be run multiple times without changing the end result.  They try to bring the server…

Naming Linked Servers v2

I've always had a love-hate relationship with linked servers.  On one hand, they are very easy to use and query.  On the other they can be a pain to configure, secure, and performance tune. I wrote about naming linked servers [https://billg.sqlteam.com/2011/08/15/how-to-name-linked-servers/] in 2011.…

ClearTrace for Extended Events

I found the time to update ClearTrace to support Extended Events.  You can download ClearTrace for Extended Events [https://www.scalesql.com/cleartrace/download/] from my corporate site.  A few notes about this build * It's a very early release.  Everything seems to work for me and it passes all 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" I've found…

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 [https://www.scalesql.com/isitsql/] 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.…

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 [http://www.scalesql.com/isitsql/] 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…