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”
Tag: Regex
Regex: Removing Restore Statement Dupes
This is a great video to show you how to think in a way that gets you a good regex. Here I’ve got SQL Continue reading “Regex: Removing Restore Statement Dupes”
Minion Backup: Regex vs. DBGroups
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
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 Word Boundaries
Here I’m going to show you how to use regex word boundaries. Word boundaries allow you to match entire words, or even words that Continue reading “Regex Word Boundaries”
Regex Lookarounds
In regex you can perform lookarounds to check for matches that don’t get consumed. These are zero-length assertions that merely report the match. Here Continue reading “Regex Lookarounds”
Find double words in regex
Here I show you how to use a backreference in regex to be able to find double words in regex. What you’ll learn how to do Continue reading “Find double words in regex”
Drop Tables in Powershell
Today I’m dropping tables based off of a regex expression and by rowcount. Good stuff here. The power of the shell shines through Continue reading “Drop Tables in Powershell”
CACTUSS Sept 2017 Meeting – Regular Expressions for the DBA
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”