Our T-SQL developer just gave his two weeks notice. We have been asked if our team of four developers would like an additional developer.We are offered to do our own T-SQL / Entitiy Framework development or we could get another dedicated T-SQL developer.What are the pros and cons with having a dedicated T-SQL developer on the team?Which would you prefer and why?
What are the pros and cons for having a dedicated T-SQL developer on your team?
team;tsql
If you have at least one person on your team already who can:Use a database profiler to get accurate useful metricsAnalyze an execution plan and know how to affect said execution planCorrectly name the tradeoffs between having indexes/not and the effects of adding/removing columns from said index.Define a clustered indexDictate from memory what normalized and denormalized structures are and what the levels of normalization are for.You might already have another t-sql developer who can keep the team at least in line. My list isn't comprehensive but if those things are there he can probably keep you guys out of trouble.If you don't have someone on your team who can do those things and your team does have their hands in the database, you need someone who can do those things. Unless you're completely unconcerned with the quality of the database (a valid stance if the system is tiny enough, read: under 15 tables perhaps.)