SQL Bits Mar 2022
SQLBits March 8 - 12 London Excel www.sqlbits.com-
Recent Posts
- Setting up a big query service account.
- Searching for underscores with LIKE
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 3
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 2
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 1
Archives
Categories
Meta
Monthly Archives: December 2021
SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 3
In Part 1 and 2 of this series I demonstrated how to create a Slack Integration and then use Azure Data Studio to Test the integration. These will need to be completed for the following SQL Server implementation to be … Continue reading
Posted in python, slack, SQL
Leave a comment
SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 2
This is part 2 of a set of articles Part 1 which details the setting up of the Slack Integration can be found SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 1 … Continue reading
Posted in python, slack, SQL
Leave a comment
Part 1 of a series of 3. Details how to create a Slack Bot. Later parts of the series explain how to use Azure Data Studio and SQL Server to send messages to this Slack integration Continue reading
Subqueries for XML blobs without self-referencing
One of the issues I see several times within SQL Server is people creating SQL Subqueries that reference the parent query so that an XML blob can be created. In this example The simple table query returns the table contents … Continue reading
Posted in Uncategorized
Leave a comment