CACTUSS Sept 2017 Meeting – Regular Expressions for the DBA

…useful regular expression commands. The appropriate times to use regular expressions. How to use regular expressions to write code for you. How to incorporate regular expressions into large tasks and…

This was recorded for http://cactuss.pass.org for their Sept 2017 user group meeting.

Regular expressions can help you perform incredible tasks with very little Continue reading “CACTUSS Sept 2017 Meeting – Regular Expressions for the DBA”

Minion Backup: Regex vs. DBGroups

…as well. Regular expressions can be quite complicated, which means that you can make some pretty rich exclusions. However, since this is a simple example, I also show you how…

In Minion Backup, you can use regex to include/exclude DBs from a backup. This actually works with all of the modules, so it’s included Continue reading “Minion Backup: Regex vs. DBGroups”

Regex Word Boundary Example

…they’re all about. What we’re doing here is we’re adding something to the beginning of each word. We’re turning regular column names into variables and using word boundaries is a…

It’s one thing to know the syntax for word boundaries in regex and it’s another to actually be able to use them. So here Continue reading “Regex Word Boundary Example”

REGEX: Use Lookbehind for PRINT Statements

Regular find can’t show you negative searches. That’s searches where letters don’t exist. So here I’m going to show you how to find PRINT statements that aren’t commented out. This…

Regular find can’t show you negative searches. That’s searches where letters don’t exist. So here I’m going to show you how to find Continue reading “REGEX: Use Lookbehind for PRINT Statements”