by Derek Du

Recently, we were asked to improve the performance of some SQL queries that run for 15 seconds and 30 seconds. At first, we were not sure whether the performance could be improved, given that there were about 80 million data pieces in the database. I have to admit that SQL Server is really powerful as eventually we reduced the time to 2 seconds and 6 seconds!

During the proces...

Yes, we’ve all been using spreadsheets for years (some of us, for decades now…) for simple what-if scenarios, for profit/loss statements, for reconciling bank statements, even for complex risk-analyses.
While some industry pundits are extoling the virtues of a “spreadsheet-free&rdquo...

by Derek Du

We struggled with Windows Azure websites because we couldn’t write logs. Using Log4Net to write to log files as we usually do, does not work for Azure Websites because of the limited file permission. We had to resort to email notifications or Virtual Machine when we needed to debug Azure Websites, which was a big headache!

Fortunately, it is all over now. To write t...

by Brian Terrell

Recently, I spoke to a large group of Intacct value-added resellers gathered at the Intacct Business Building Conference. I introduced several products that BTerrell and our CodePartners division developed to help Intacct client companies automate key business processes in HR, treasury, invoicing, and salesforce compensation. The conference was hugely successful, and I enjo...

by Michelle Tanner
Derek Du is one of our lead software developers. We thought it would be helpful to get some insight from him on his job and how he approaches each project to ensure success of the application and the happiness of the client.

1.  As a client manager and software development engineer, what is your favorite part of your job?

I like the opportunity to work on a variety...