Mike Sherrill 'Cat Recall'

less info
101 reputation
1
bio website
location United States
age
visits member for 6 months
seen Oct 4 '13 at 21:51

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 not answered any questions
This user has not asked any questions
This user has not participated in any tags
Stack Overflow 34,244 rep 22754
Database Administrators 5,187 rep 823
Programmers 1,486 rep 411
Server Fault 298 rep 111
Webmasters 225 rep 210

1 Vote Cast

all time   by type  
1 up 0 question
0 down 1 answer