Category Archives: Internet Marketing

Q&A: Can you do a nested SQL query in Responsys?

Although I have not heard this directly from Responsys, I believe you can execute any SELECT statements that can normally be executed on an ORACLE database. We run this SQL statement, where you can see nested select statements:

SELECT * FROM ( SELECT RANK() OVER (PARTITION BY A.EMAIL_ADDRESS_ ORDER BY A.CREATED_DATE_) RNK, A.* FROM $A$ A JOIN (SELECT EMAIL_ADDRESS_ FROM $A$ GROUP BY EMAIL_ADDRESS_ HAVING count(EMAIL_ADDRESS_) > 1) B ON (A.EMAIL_ADDRESS_ = B.EMAIL_ADDRESS_) ) WHERE RNK <> 1

Twitter goes down, what’s the fallback service?

So Twitter is experiencing an apparent DOS (denial of service) attack. That begs the question: If twitter goes down, and twitter is the main way people get their updates, how would anyone know? Since, obviously, you can’t tweet out that Twitter is down, where do you turn to get a mass message out to all your friends that they can no longer follow you on twitter until the issue is resolved? Continue reading

Facebook is becoming the new AOL

I’m beginning to hear my co-workers and friends start to complain about Facebook. The complaints aren’t centered around the latest homepage changes or the some feature that changed, as has been the case in recent months with Facebook making updates to its design and user experience. No, these folks complaining are concerned about one thing: old people.
Continue reading

Network Solutions reinvents itself….sort of.

Today Network Solutions launched a preview of it’s reinvented branding and service offerings. If you have been around the internet long enough, you’ll remember Network Solutions was one of the first major domain registrars to come along and offer the ability to own your own piece of internet real estate in the form of a domain name. Back then, paying $35 for a domain name seemed appropriate for what you were buying, and people were more than willing to plop down the dough. Continue reading