Mike Sherrill 'Cat Recall'

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

5,187 Reputation

10 yesterday
10 Apr 16
+10 12:03 upvote
10 Apr 10
10 Apr 9
30 Apr 6
10 Mar 24
10 Mar 15
10 Mar 13
10 Feb 20
10 Feb 6
30 Feb 3
10 Dec 21 '13
10 Dec 18 '13
10 Dec 10 '13
10 Dec 6 '13
10 Nov 18 '13
20 Oct 30 '13
40 Oct 18 '13
10 Oct 4 '13
10 Sep 28 '13
20 Sep 27 '13
0 Sep 13 '13
10 Sep 12 '13
20 Sep 10 '13
10 Sep 9 '13
10 Sep 7 '13
10 Sep 4 '13
10 Aug 13 '13
25 Aug 6 '13
0 Aug 2 '13