News for hackers. Stuff that matters.
Re:How StackOverflow Scales with SQL Server by BrentOzar on Thursday November 17, 2011 @07:22AM (#3247393)
I consider DBA-level skills as the ability to read an execution plan, figure out what indexes are being used, know the difference between a good plan and a bad one, and figure out how to rewrite your query to get the performance & plan you want without just adding indexes willy-nilly. Another good example would be knowing when it's right to normalize tables versus flattening out the data structures - you can't just knee-jerk and normalize everything because it's the best practice.

I wouldn't say that developers need to know about HA/DR, replication, memory tuning, SAN setups, etc, though. Just the how-queries-work and how-data-is-stored angles.

Thanks for the compliments! I had fun doing that one.

There are no comments on this comment yet.