SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Wednesday, September 08, 2010
When Design Goes Bad, and The ‘One table to Rule Them All!’
Via an interesting article from Joe Celko on bad practices in database design and the horrors of EAV (Entity-Attribute-Value) tables, there is a link to a great read on the ultimate ‘One table to Rule Them All’! I find this tale very pertinent as I once did a short stint at a company with ‘start’ in their name, that had created a design with a single table for static data (although no where near as bad as the one described in ‘Bad CaRMa’).
MSN, Email: mitch døt wheat at gmail.com