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.
Q&A for professional and enthusiast programmers
Q&A for database professionals who wish to improve their database skills and learn from others in the community
Q&A for professional programmers interested in conceptual questions about software development
Q&A for professional system and network administrators
Q&A for pro webmasters
Q&A for peer programmer code reviews
Q&A for users of Linux, FreeBSD and other Un*x-like operating systems.
Q&A for Information security professionals
Q&A for computer enthusiasts and power users
Q&A for meta-discussion of the Stack Exchange family of Q&A websites
Q&A for WordPress developers and administrators
Q&A for power users of web applications
Q&A for statisticians, data analysts, data miners and data visualization experts
Q&A for user experience researchers and experts
Q&A for people wanting to improve their personal productivity
Q&A for speakers of other languages learning English
Q&A for Ubuntu users and developers