Mike Sherrill 'Cat Recall'

less info
97 reputation
2
bio website
location United States
age
visits member for 2 years
seen 17 hours ago

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.

This user has no recent positive reputation changes
This user has not asked any questions
Stack Overflow 34,199 rep 22754
Database Administrators 5,187 rep 823
Programmers 1,486 rep 411
Server Fault 298 rep 111
Webmasters 225 rep 210

24 Votes Cast

all time   by type  
24 up 11 question
0 down 13 answer