Mike Sherrill 'Cat Recall'

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

147
× 36
13
× 3
8
× 3
5
× 2
114
× 36
12
× 6
8
× 3
5
× 2
95
× 27
12
× 6
8
× 3
5
59
× 17
12
× 4
8
× 2
5
51
× 27
10
× 5
7
× 2
5
48
× 14
10
× 4
7
× 2
5
31
× 9
10
× 3
7
× 2
5
28
× 5
10
× 3
7
4
× 4
26
× 7
9
× 7
6
× 3
4
× 3
24
× 6
9
× 3
6
× 2
4
× 2
17
× 6
9
× 2
6
× 2
4
× 2
16
× 3
9
6
4
13
× 7
8
× 3
5
× 2
4