Mike Sherrill 'Cat Recall'

less info
141 reputation
6
bio website
location United States
age
visits member for 2 years
seen yesterday

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
19
revised Can I tell which applications embed Internet Explorer at a command prompt?
Reworded.
Aug
7
revised Intrusion attempt? Host 'somedomain.org' is not allowed to connect to this MySQL server
New developments point to the Ukraine.
Aug
6
revised Intrusion attempt? Host 'somedomain.org' is not allowed to connect to this MySQL server
Added that this is a one-time error.
Apr
10
revised How to keep a shared web hosting server secure?
Updated link to cisecurity.org