Cool OneNote feature

I was already very impressed by OneNote, but I am blown-away after stumbling upon the built-in OCR capability.  When I did a content search for “Attendee” it not only found the image, it even highlighted the word on the image!

 

Removing the Dell DataSafe Upgrade Discount pop-up

I was baffled by a Dell product pop-up that did not appear to have a way to disable/ignore it...until I unlocked the taskbar and resized it. After that, the entire ad was displayed, including the option "Don't remind me of dicount offerings". Now if I can just get Dell to reimburse 30 minutes of life.

Mail Merge Templates No Entity error

I removed an entity that we were no longer using, but the Mail Merge Templates were still there.  CRM throws an error when there are templates that are missing their entity.  I discovered this by running the CRM Diag Tool and the CRM Trace Log Viewer.

 

To fix this, I had to manually set the records to “deleted” in the CRM database (DeletionStateCode=1).  Lesson learned: remove Mail Templates before deleting an entity!

 

 

 

Oracle regexp_replace function

I needed to remove non-ASCII characters from an Oracle column and this regular expression did the trick nicely:

 

update TABLE set COLUMN = regexp_replace( COLUMN,'[^a-z,_, ,A-Z,0-9,@,&,$,:,.,%,'']','');