Home > Articles > Data

  • Print
  • + Share This
Like this article? We recommend

Effective Code Reviews

Production DBAs typically don't write application code. Occasionally, DBAs contribute to development efforts, but normally developers end up writing all application stored procedures, views, user-defined functions, and triggers. On the other hand, performance tuning and ensuring application scalability is normally the DBA's responsibility. Therefore, it's the DBA's job to mentor and advise developers on writing efficient code. Depending on experience level, a DBA could also learn a thing or two from developers.

Code reviews are a great way to learn an unfamiliar application and pick up some new coding tips and tricks from your colleagues. Developers should invite DBAs to Transact-SQL code reviews. The point isn't to grill your coworkers or get mad at each other; rather, the idea is to learn from what others have to say and grow by collaborating.

  • + Share This
  • 🔖 Save To Your Account