News for hackers. Stuff that matters.
Re:Every .NET Developer Should Know Their Database Well Enough by xradionut on Monday August 29, 2011 @06:50AM (#2936701)
Article assumes that a .NET developer will only be connecting to a MS SQL Sever database and not a third-party database like Oracle, Postgres or SQLite... Other than that it's not a bad article except the number one problem I see among developers that don't understand SQL Server is how and when to use indexes.
Re:Every .NET Developer Should Know Their Database Well Enough by ams6110 on Monday August 29, 2011 @10:05AM (#2937206)
A related problem is developers who do have a decent understanding of SQL Server then going to something like Oracle and thinking that all their best practices are still correct. You not only need to know about database generally, but you need to be familiar with how your SPECIFIC database works and how it's different from others you may have used.
Re:Every .NET Developer Should Know Their Database Well Enough by Halienja on Monday August 29, 2011 @07:10AM (#2936744)
I agree to xradionut. The article has good information but only a couple of index related links. The how, why and when of indexes will complete the article