I had an issue recently raised that when we tried to send a bulk email report to over 1000 users there was a significant delay in their delivery between first and last email. Upon investigation at first the issue looked like the connectivity from the recipient’s end to be the culprit. However on more detailed […]
Monthly Archives: September 2013
Strip text and extract numeric value from string using TSQL
Today I had an issue that someone changed format of a string pattern our SQL was expecting. I came across a function written by George Mastros that addressed my SQL needs. Long story short we have a string with text then a number and some more text. What we need is to extract the numeric value from this […]
Time services fixup on Windows
I keep having to deal with this issue every now and then so I figured I might as well record what commands are needed to fix it up 99% of the time: w32tm /config /manualpeerlist:”time.nist.gov time.windows.com time-nw.nist.gov time-a.nist.gov time-b.nist.gov time-a.timefreq.bldrdoc.gov time-b.timefreq.bldrdoc.gov time-c.timefreq.bldrdoc.gov utcnist.colorado.edu” /syncfromflags:manual /update and then (note you can replace the server list with […]