Monster Text Manipulation: Regular Expressions for the DBA

Sean McCown

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures, filled with table variables, instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cut that work from hours or days to minutes or even seconds.

Stop writing code manually and let regular expressions do it for you. Learn:

  • The most 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 combine them with other methods