Ed Mays (10/6/2008)

---

I am trying to decrypt data that was encrypted via PHP/mcrypt and stored in a MySQL database originally. We have a SQL Server that needs to process...

"No good deed goes unpunished..." 🙁

I think the reference is to Sisyphus although development work can also make you feel like you're being eternally restrained and punished (by having your liver ripped out?) as well...

On 2005, the full-text index is not going to help greatly. The problem is that you can't define patterns in full-text index search. You can search for numeric...

Good article! One question did come to mind as I read it: would it be possible to modify your method to use a single XML schema for validation against...

Ha 🙂 Well, I believe my name is printed somewhere on it - that's just as good 🙂

MarkusB (7/29/2008)

---

Don't wanna be too picky but from the answer:

The “//*” XQuery path matches every element node in the XML document, so (b) is also incorrect.

And I thought "B" was...

jsleichty (7/25/2008)

---

Has anyone used the xp_blowfish dll on SQL 2005? We just moved to a new server and we're getting error messages to the effect.

Could not load the DLL...

Hi all,

Thanks for the feedback. The difference between varchar, nvarchar, and xml is an interesting aspect of XML storage. The gist of it is that the xml data...

tnolan (7/21/2008)

---

Sorry guys, my soundex suggestion was not meant entirely seriously. The typo function provided here is pretty well done, but I think adding phonetic search would add to...

gcopeland (7/21/2008)

---

I think a hash table would be a much better implementation. It would be hugely faster, and if the word doesn't hash, it would be easy to grab...

Soundex is horrible. And the SQL Server implementation doesn't match with the NARA...

Hi Atif,

If Steve notified you that you won then it should be mailed out to you shortly. I believe it's being mailed out directly...

Hi all, I've been away for a few. To answer your question Miles, try eliminating the line break in the URL. It was put in for formatting purposes,...

Holy Cow! Thanks everyone! I just got around to reading today's newsletter and ran across this press release. I appreciate all the help and support from everyone...