Mike Sherrill 'Catcall'less info
|visits||member for||1 year, 1 month|
|seen||May 15 at 10:50|
Long-time database design and software development consultant. My clients included evetrything 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.
|2||Sep 25 '12|
|5||Sep 24 '12|
|3||Sep 22 '12|
|-2||Sep 20 '12|
|3||Sep 19 '12|
|2||Aug 8 '12|
|5||Aug 7 '12|
|15||Aug 4 '12|
|102||Apr 10 '12|