This week, I was given a set of data to import to a database. After the import, I noticed that the source data had lots of unnecessary spaces all over the place. I can, of course get rid of leading … Continue reading
After that previous post, I suppose it was natural for me to wonder what it would take to apply Vigenere cypher logic using T-SQL. I knew right off that the code would look much different. Mainly, because my self-imposed rule … Continue reading
Recently, I rewatched The Prestige, the very good Christopher Nolan move where Hugh Jackman and Christian Bale play rival magicians in the late 1800s. Jackman’s character has an old journal, written in cypher text that he slowly and meticulously needs … Continue reading
You can join data sets. LEFT JOIN, RIGHT JOIN, even OUTER APPLY. There’s nothing to learn here. Last week, I had what seemed to be a simple join of three data sets. My permutation was a lot more complicated than … Continue reading
All php developers have been there. You’ve got the page working just like it should. And with one exception, it looks good too. That exception: All of your status and debut messages. You hate to get rid of it. It’s … Continue reading
I ran into an interesting need when updating some code for MyQuizWiz, an online quiz and survey system that I developed. There’s a need to display content generated by the system in users’ Facebook fan pages.. Specifically, there is a … Continue reading