No Picture

Automatically posting messages to slack

September 22, 2018 jlion 0

SQL Server supports SQL Mail for email notifications, and traditionally I’ve used SQL Mail to keep myself apprised of various server issues.

Slack is a great alternative to email, and a lot of folks make extensive use of slack. I thought it would be nice to receive notifications from SQL Server in a slack channel, and so started looking into …

No Picture

CLR stored procedures in sql server

September 13, 2018 jlion 0

To create a CLR stored procedure in SQL Server….

I used this nice blog posting by Scott Sutherland as a starting point:

If you are using SQL Server 2017 it will be necessary to sign your CLR assembly.

If you are doing this in a development environment, you may wish to create a public/private key pair:

Once you’ve …