I'm a software developer and consider myself to be a database developer as well (as opposed to a db administrator).  As a developer, I'm comfortable doing the following tasks from Steve's list:

§         Install SQL Server, at least a basic installation.

§         connect to a server  

§         create a database  

§         write simple queries, including at least a 3 table inner join

§         understand what the WHERE and ORDER BY clauses mean

§         basic aggregation queries, perhaps one non-aggregated column along with the totals

§         comfortable with using the import and export wizards

I am not experienced with the other tasks on his list.  However, I'm also comfortable with db design (including data types, relationships and constraints) writing queries with complex joins (multiple tables), stored procedures, views, functions, triggers, .  Of course, inserts, updates and deletes are no problem either.

Truth be told, I enjoy the db development work as much if not more than the software development work (which I also enjoy) and sometimes consider exploring the possibility of becoming a full-time (junior) dba, or even better, a full-time db developer (if such a position exists).

I'd be curious to know if anybody, including Steve, had any thoughts about whether my current skill set would be in demand for one or both of these positions??? (I think this question ties in with Steve's original question).

Thanks.