Entries by Paras Mutneja

Avoiding the SQL "Division by Zero Encountered" Error

When writing queries that perform lots of calculations, it is very easy to forget to ensure that our queries are set up to avoid the “Division by zero encountered” error. Luckily, there are three easy workarounds to avoid getting this ugly error in our SELECT statements: CASE statement NULLIF/ISNULL functions SET ARITHABORT OFF and SET […]

Diving deeper into the Redmine Backlogs Plugin

Agile software development practices are now common and are even finding their way in to large companies that don’t readily embrace change. With the rise of agile has come a number of tools for managing agile software development projects. One tool that we have worked with here is the Backlogs plugin for Redmine which turns […]