Category Archives: SQL

Searching for underscores with LIKE

Posted on January 14, 2022 by ph1lqu1nn

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 | Leave a comment

SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 3

Posted on December 24, 2021 by ph1lqu1nn

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

Posted on December 24, 2021 by ph1lqu1nn

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 →

Posted on December 24, 2021 by ph1lqu1nn | 1 Comment

Schema visibility using xml_schema_namespace

Posted on November 1, 2012 by ph1lqu1nn

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 | Leave a comment

being silly with spatial data

Posted on October 4, 2012 by ph1lqu1nn

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 | 2 Comments

Schema validation using Reg Ex

Posted on September 20, 2012 by ph1lqu1nn

One of the most powerful tools that XML in SQL Server brings to the table is Regular expresions. In XML Schemas Regular Expressions are an easy method to validate your data without having to bolt on complex CLR functions to … Continue reading →

Posted in SQL, XML | Leave a comment

XML .value simple syntax

Posted on May 7, 2012 by ph1lqu1nn

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 | Leave a comment

Reducing size of a nonclustered index with Filtering

Posted on December 4, 2011 by ph1lqu1nn

SQL Server 2008 has a very nice new feature that enables a partial index to be created based on a specific where clause. I have recently used this as an solution checking a table that contained an isSent flag. by creating a … Continue reading →

Posted in database performance, filtered indexes, non-clustered Indexes, SQL, Uncategorized | Leave a comment