Intel’s Meltdown and database performance

Unless you’ve been on an extended Christmas break with no TV or Internet, you’ll have heard of Intel’s recent troubles. While it’s true that most computers will not be noticeably affected, servers that read and write large amounts of data to disk will be impacted. In my world, that affects two things – databases and reports. Large queries… Read More »

Still have a single CPU licence for reports?

This is the first in a series of posts about licence compliance. It’s always difficult to get independent advice on licensing, so I’m attempting to highlight some potential pitfalls. Given the complexities and potential liabilities, you should always refer to your own licences. I’ve been trying to source some useful guidelines from SAP without success. First of all,… Read More »

Report performance tuning

Customer: Aviation Software House Our customer had an important report that was taking over 10 minutes to run for just a month’s worth of data. New requirements mean that the report needed to be run for a year’s worth of data. Obviously a problem! As is so often the case, the main performance problem was due to subreports.… Read More »

Predictive Analytics in HR

I’ve had an interesting month experimenting with Predictive Analytics using a customer’s anonymised recruitment data. First, I used SAP Predictivie Analytics. It’s a great product, but I found that I felt ‘too distant’ from the analytics process. While the end result is explained in statistical terms, I wanted more control over how the result was generated. I’ve experience… Read More »

Crystal Server 2016 – July Update

Since my original post about the licensing updates, there has been further clarification from SAP. There are now two separate ways of licencing Crystal Server. The ‘old’ way of just buying some licences and paying an annual maintenance fee to a reseller, or the new way of signing a maintenance agreement with SAP as part of the purchase… Read More »