No, I don’t mean the SQL Server community on Slack—although you should definitely join up there.
I have a client whose primary method of communication is Slack. They have e-mail accounts, but hardly use them. They also have no real monitoring solution in place, so I wanted to be able to do some quick checks and, in the event of an error, push a message to a Slack channel that they could monitor.
It turns out that there is already a Github repo for a CLR function to push a message out to Slack. The folks at PowerupCloud have a nice step-by-step walkthrough on how they did it. I wish they had continued the series on integrating further, particularly around SQL Agent alerts. If you’re a paying Slack customer, you can integrate e-mail with Slack. You could also throw Zapier into the mix and possibly get a free integration point.
If you want to avoid the external integration process, you can read the default trace or system health XE (about which I learned a lot from Ed Leighton-Dick’s presentation on the topic) and write calls to Slack based on results there.
One thought on “TIL: Slack + SQL Server”
Glad that you found our post useful. We will continue with the series on integrating further and post links here 🙂