Sending messages to Slack from SQL Server

Using python in SQL Server to send messages to Slack workspaces

Slack can receive emails from SQL server but the formatting of information can be poor compared to the native Markdown language, In this session I will be showing how to create a simple Slack Bot. Install SlackClient python packages to SQL Server. Test the Slack Bot python code in Azure Data Studio to send messages to your slack workspace. Finally implementing the code to run from a SQL Instance using sp_execute_external_script. I will also do a small Introduction to Markdown language for Slack to improve the formatting of Messages.

Speaker

Phil Quinn an avid interest in SQL XML and other obscure sql that often has no practical application.

Phil Quinn's Sessions

Sending messages to Slack from SQL Server

XML: The Marmite of SQL Server