Mike Sherrill 'Cat Recall'

less info
141 reputation
5
bio website
location United States
age
visits member for 2 years
seen Apr 8 at 18:11

Database design and software development consultant. My clients included everything from Fortune 100 companies to non-profits and mom-and-pop companies. I've worked with SQL databases since 1985. I'm a database generalist; I'm comfortable with every modern SQL dbms. My home server runs a half-dozen different database management systems. I test most of my answers under more than one of them.

I've also developed relational models for implementation in non-SQL environments, like Lotus Notes and plain C++ code.

I'm known for frequently saying

  • ID numbers have nothing to do with normalization.
  • Everything you know about state codes is wrong.
  • Table names, column names, etc., are your database's API.
  • Natural keys reduce the number of joins, and often improve performance.
  • 5NF is your friend.
  • Don't assume. Test.

Sep
20
comment Can I tell which applications embed Internet Explorer at a command prompt?
@Ramhound: There are many dozens of apps, and my time is limited. Currently there are exploits in the wild, and there isn't yet a patch for IE. My edited question and comments change the context a little; I want to know how I can identify apps that embed IE, preferably from the command line. When Germany asks the public to stop using IE, it's a little bit more than the typical IE hatred.
Sep
19
comment Can I tell which applications embed Internet Explorer at a command prompt?
Knowing the types of apps won't help me manage my time. I need a waving, red flag that says, "This one's trouble." And, in my own question's defense, the edit doesn't ask which apps have IE embedded. It asks, "Is there a way to tell which apps have IE embedded?"
Sep
19
comment Can I tell which applications embed Internet Explorer at a command prompt?
@Iszi: Thanks for the guidance. I rewrote the question and the text.
Sep
19
comment Can I tell which applications embed Internet Explorer at a command prompt?
@GdD: You're mostly right. I want to know which applications are known to imbed IE.
Aug
8
comment Intrusion attempt? Host 'somedomain.org' is not allowed to connect to this MySQL server
On a shared host, it makes sense to report it to the shared host's tech support, too.
Aug
7
comment Intrusion attempt? Host 'somedomain.org' is not allowed to connect to this MySQL server
I could buy that explanation. On the other hand, see my latest edit to my question, "Still later...".
Aug
6
comment Intrusion attempt? Host 'somedomain.org' is not allowed to connect to this MySQL server
@AndySmith: It explicitly uses the correct hostname. In testing and in production, it connects to the right host, emails the right people, and inserts the right rows.
Aug
6
comment Intrusion attempt? Host 'somedomain.org' is not allowed to connect to this MySQL server
@AndySmith: Makes sense, but no, it's using the right hostname. (I checked.) If the hostname were wrong, I'd get that error every time. I've only seen that error once, though. The rest of the time it's worked fine.