Posts

Showing posts from November, 2017

SQL Pattern Matching Deep Dive - the PDF Version

Image
Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference. The title of each blog post started with SQL Pattern Matching Deep Dive...and covered a set of 6 posts:

Part 1 - Overview
Part 2 - Using MATCH_NUMBER() and CLASSIFIER()
Part 3 - Greedy vs. reluctant quantifiers
Part 4 - Empty matches and unmatched rows?
Part 5 - SKIP TO where exactly?
Part 6 - State machines

There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. One of the challenges, even when searching via Google, was tracking down all the relevant content.

Therefore, I have spent the last 6-9 months converting all my deep dive content into a book and I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer SQL forum, discussions with my development…

SQL Pattern Matching Deep Dive - the book

Image
Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference. The title of each blog post started with SQL Pattern Matching Deep Dive... and covered a set of 6 posts:


Part 1 - OverviewPart 2 - Using MATCH_NUMBER() and CLASSIFIER()Part 3 - Greedy vs. reluctant quantifiersPart 4 - Empty matches and unmatched rows?Part 5 - SKIP TO where exactly?Part 6 - State machines

There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. One of the challenges, even when searching via Google, was tracking down all the relevant content.

Therefore, I have spent the last 6-9 months converting all my deep dive content into a book - an Apple iBook. I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer SQL forum, discussions with my deve…