Passed 70-229

[IT4EVR]

I passed the 70-229. Contrary to popular belief, this test was NOT easy. I'm not sure this test represents the core areas an application developer needs to know for SQL Server.

I saw more than a few questions regarding index tuning, etc. Normally this is under the realm of the DBA. I guess it depends on the company, but the protocol I'm accustomed to is to allow the DBA to handle these chores. Does an application developer need to worry if the statistics are updated? Does an application developer concern himself/herself with making configuration changes in SQL Server for handling cursors? Again, where I work the DBA usually handles that.

One question involved using a view to insert data. I really never use this approach. I tend to use Stored procedures.

I would have liked to have seen more TSQL questions.

I'm not a big fan of the content of the Microsoft tests, however I take them anyway The only way you are going to determine if someone really knows their stuff is to write some code, not click A, B, C or D.

 

[mrdenny]

Mostly those tasks would fall to a DBA. Keep in mind that 70-229 is part of the MSDBA exam. The exam is geard towards us DBAs. In the SQL 2000 world there isn't a SQL Developer only exam. Look into the SQL 2005 exams. For SQL 2005 there is the MCITP: Database Developer cert.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[IT4EVR]

Ok, I can see your point. I took it as an elective exam. I should probably stop complaining...