Every .NET Developer Should Know Their Database Well Enough

Re:Every .NET Developer Should Know Their Database Well Enough by silverbax88 on Monday August 29, 2011 @08:42AM (#2936929)

I know the discussion on this page will likely devolve into a technical discussion of minutiae, but the point of the article is dead on. As a .NET programmer, I know a lot about databases - Oracle, SQL Server, MySQL, RavenDB, Couch and so on. I would never consider myself a DBA, and in fact, I always felt that I should understand databases a lot more.

One thing I've discovered over the years is that most .NET programmers - even seasoned ones with good programming knowledge - don't know squat about databases. In fact, I believe that's why so many programmers jump to something like Linq or NoSql, not because they think it's the best choice for the job, but rather because they simply don't understand databases.

It's my opinion that if you can't do most of your data manipulation in your data layer, and you really understand SQL (which is, quite frankly, cake compared to any other programming language except HTML), you are missing a huge chunk of knowledge that you really should have.

[ Parent | on HN ]

Re:Every .NET Developer Should Know Their Database Well Enough by onemoreact on Monday August 29, 2011 @09:55AM (#2937169)

Other than understanding SQL I think the #1 issue for most developers is understanding database preformance. The most basic understanding of indexes and how the database parses commands goes a long way.

PS: If you don't understand the value of 'Explain' or your local databases equivelent then a day or to is all it's going to take to save yourself from a world of pain.

[ Parent | on HN ]