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 →

Posted in SQL, XML | Tagged , | Leave a comment

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 , , , , , | 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 →

Posted in Uncategorized | Tagged , , , | Leave a comment

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 →

Posted in SQL, XML, XML Schemas | Tagged , , | Leave a comment

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 →

Posted in spatial data, SQL | Tagged , | 2 Comments

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 →

Posted in SQL, XML | Tagged , , , , | Leave a comment