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
Tag Archives: T-SQL
Searching for underscores with LIKE
I got caught out by a Gotcha which has caught me out many times and hopefully wont again ( but it will). I was looking for a specific piece of text within a sql module in a Database, simple right! … Continue reading
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
Tagged Alerting, Azure Data Studio, python, slack, SQL Server ML Services, T-SQL
Leave a comment
Auditing Your Database Changes
SQL Server can capture Database level Trigger information using XML. I personally use this on my home PC’s because I’m poor and can’t afford one of those amazing DB Source control products that are out there on the market. I’m … Continue reading
Schema visibility using xml_schema_namespace
One of the issues I’ve faced is the constant referencing and rereferencing of XML Schemas that are stored against a database. the xml_schema_namespace dmv helps with this. it takes 2 parameters. the schema of the database object XML Schema and … Continue reading
being silly with spatial data
Okay, a fun post with no educational value (sort of). My Adopted Twin, also a Database geek, has been under the weather recently so to cheer her up I have been playing with spatial data, under her orders to create … Continue reading
XML .value simple syntax
There are several ways to get .value to extract an item of information from xml. in the following article I will show some of the syntax and reasons why some methods are better than others. All the calls in this … Continue reading