Mike Sherrill 'Cat Recall'

less info
5,177 reputation
823
bio website
location United States
age
visits member for 3 years, 1 month
seen 42 mins 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.

147
× 36
48
× 14
114
× 36
31
× 9
95
× 27
28
× 5
59
× 17
26
× 7
51
× 27
24
× 6
Stack Overflow 34,129 rep 22754
Database Administrators 5,177 rep 823
Programmers 1,486 rep 411
Server Fault 298 rep 111
Webmasters 225 rep 210

165 Votes Cast

all time   by type   month  
155 up 39 question 1
10 down 126 answer