Mike Sherrill 'Cat Recall'

less info
225 reputation
210
bio website
location United States
age
visits member for 2 years, 6 months
seen Nov 12 '13 at 2:06

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.

Stack Overflow 34,144 rep 22754
Database Administrators 5,177 rep 823
Programmers 1,486 rep 411
Server Fault 298 rep 111
Webmasters 225 rep 210

20 Votes Cast

all time   by type  
20 up 10 question
0 down 10 answer