Activity overview
Latest activity by SQL.Dave
Modified Snippets Lost After Upgrade To SQL Prompt 5.3.4.1
I updated my SQL Prompt to version 5.3.4.1 today and after logging off my PC and logging back on, all of my custom SQL Prompt snippets are gone. A search of my hard drive turns up nothing. In their...
Enhancement: Regex Filter on Deadlock Alert Configuration
It would be helpful to filter deadlock alerts with regular expressions, in the same way RegEx can be used to filter long-running query alerts.
We have several third-party apps (which shall remain n...
Unfortunately, simply checking the regular expression syntax doesn't tell the user if the regular expression will identify the desired text.
Example: I want to filter out long-running query alerts caused by xp_sqlmaint. Depending on which server the job is running, xp_sqlmaint may be entered in the TSQL code as xp_sqlmaint or xp_SQLMaint. Will (?i)xp_sqlmaint work for the regex filter? Do I need to specify xp_[Ss][Qq][Ll][Mm]aint? A syntax check alone does not tell me the answer.
A third-party regex application could work. That's why I originally suggested the regex tester on regexlib.com (your help file already has a link to regexlib.com). The problem is that regex testers have configuration options for things such as case-sensitivity. As a DBA (not a .NET coder), I have no idea what options I should set on a third-party testing tool so it emulates the .NET regex library.
I would appreciate an enhancement request that at least identifies the settings for a given third-party regex tester that will guarantee that tests performed there will behave the same way in the SQL Monitor software. This will prevent a lot of trial and error when tuning SQL Monitor alerts.
BTW, regexbuddy is very reasonably priced at $40, but it's not free. / comments
Unfortunately, simply checking the regular expression syntax doesn't tell the user if the regular expression will identify the desired text.
Example: I want to filter out long-running query alerts ...
RegEx Enhancement
It would be very handy to have RegEx test functionality in the alert configuration screen. This could be something as simple as including in the help content the correct settings for the regexlib.c...